web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Edit In Excel: Change ...
Small and medium business | Business Central, N...
Answered

Edit In Excel: Change default columns?

(0) ShareShare
ReportReport
Posted on by EGMX 41

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?

I have the same question (0)
  • 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

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 94,560 Super User 2025 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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,106

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,291 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,010 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans