Export more then 5000 rows to excel

Jatin_Patel

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?

kine

You need to set it in C:\Users\<yourlogin>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\71\ClientUserSettings.config but on the Citrix server...

Jatin_Patel

Thanks Kine. It resolved my issue.