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

Notifications

Announcements

No record found.

News and Announcements icon
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)
  • Verified answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

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

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

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

  • Community Member Profile Picture
    Community Member on at

    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.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans