News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

Posted on by EGMX

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?

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (1)

Report

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 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans