Microsoft Dynamics NAV The no. of records in the table exceeds the max. no. of 5000

Ronnie Alstrup Ziegler
Ronnie Alstrup Ziegler used Ask the Experts™
on
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.

Any ideas?

Thanks,
Ronnie
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
In Tools -> Options -> MaxNoOfXMLRecordsToSend the number entered has to be without the <> then it's accepted.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial