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 / 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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans