Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Export more then 5000 ...
Microsoft Dynamics NAV (Archived)

Export more then 5000 rows to excel

(0) ShareShare
ReportReport
Posted on by Jatin Patel 2,641

Hi,

I am using NAV 2013 R2 from citrix cloud.

when i am using Print & Send -> Microsoft Excel option i am getting below error:

Microsoft Dynamics NAV

---------------------------

The number of records in the table exceeds the maximum number of 5000. Set a filter to decrease the number of records in the table. Exporting too many records at once can affect system performance.

---------------------------

OK

---------------------------

i have tried following solution but not working:

1 - Tools -> Options -> Max. no. of XML records to send

2 - Change parameter in file C:\Users\admin\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\71\ClientUserSettings.config

3 - Change parameter in file C:\ProgramData\Microsoft\Microsoft Dynamics NAV\71\ClientUserSettings.config

Not any option is working for me.

How to fix this for Citirix cloud?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export more then 5000 rows to excel

    I've fought this limit for years.

    Which is insame as the most rudimentary programs OTHER than NAV will export out 1 million rows of data to Excel if you ask them to.

    What an antique.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export more then 5000 rows to excel

    Select all rows in table, press Ctrl+Shift+C (Copy Rows), open Excel, press CTRL+V to paste.

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Export more then 5000 rows to excel

    Try to open codeunit 424 and find the function CheckNoOfRows. What is the value in NoOfRows?

  • Verified answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at
    RE: Export more then 5000 rows to excel

    You need to modify ClientUserSettings.config file stored in your user folder on Citrix server, that's the one used based on your architecture.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans