How To: To increase the Max no. of XML/ Excel export from NAV 2009

Step 1: Locate ClienUserSettings.Config file under C: -> Users -> Username -> AppData -> Local -> Microsoft -> Microsoft Dynamics NAV -> ClienUserSettings.Config

Step 2: Edit the file using Text Editor

Step 3: Insert the following line

<add key="MaxNoOfXMLRecordsToSend" value="20000" />

Text in red determines the maximum no. of records to be exported.

Finally, save the file.

Note: Take a backup of the .config file before making any changes to it.