Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Export to Excel - default folder

Posted on by Microsoft Employee

Is there a setting for the default folder for Excel's exports? When export to Excel by pressing Ctrl+E it asks to save it somewhere, but if you just press 'open' then it's saved in NAV's temp folder. Is there are way to set it to a default location? I tried setting the default location within Excel, but NAV ignores it.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: Export to Excel - default folder

    Hi, As far as I know, there is no good way. When many softwares directly open the files, they put the files in the temporary folder first.
    It is recommended to use Save, which will save the last folder location.

    pastedimage1658186674498v1.png

    pastedimage1658186685936v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export to Excel - default folder

    It's not about creating a new report or page. I want to set a default folder for all the native NAV pages. Sales Order list, for example.

  • KTA Profile Picture
    KTA 1,200 on at
    RE: Export to Excel - default folder

    Giving the path in createbook doesn't work?

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans