I have a user running Microsoft Dynamics NAV Classic 2009 on Windows 10. She cannot export more than 5000 records to Excel. The error is The no. of records in the table exceeds the max. no. of 5000. I've added the line <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> to her clientusersettings.config file. There is no other file with that name, so it must be the right file.
I cannot change the value using Tools -> Options as I get the message that I cannot type the number in a integer field no matter what number I use. The value here is 5000, but even if I type 5000 I get the error message.