Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Edit In Excel: Change default columns?

Posted on by 29

Hi everyone. I've run into a bit of a conundrum: I'm aware you can add columns to a table by using Edit in Excel. Similarly, I'm aware some columns are hidden by default and you can choose to reveal them through the "Design" option in the connector. However, is there a way I could manually determine which columns are shown by default? What if a couple of my dimension values are hidden that I regularly want to fill out in Excel? Is there a property that I could assign or option that I could change that would make them always show up to anyone who downloaded the file?

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,171 Super User 2024 Season 2 on at
    RE: Edit In Excel: Change default columns?

    Hi, As far as I know, the Edit in Excel function has nothing to do with the fields displayed on the page, so we cannot specify the required fields before exporting.

    We can only show or hide some fields after export.

    But this Excel should be reusable, you can directly share the organized Excel file with other users, it should be able to solve this problem.

    PS: Before exporting, we can specify filters.

    https://yzhums.com/22941/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Edit In Excel: Change default columns?

    There is some discussion on this topic here

    community.dynamics.com/.../how-to-edit-gl-journal-template-in-d365-financials

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans