Export more than 5000 records to excel in Dynamics NAV

Hello Friends,

Dynamics NAV default setting doesn't allow user to export more than 5000 rows to excel in NAV 2013 and newer version.

If user want to export more than 5000 rows to excel than we need to update following parameter in user custom setting files.

update the tag value: <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> in user configuration file.

File is located in respected version folder:

Update the value in following parameter.

You can find the user configuration file at following location:

Windows Server 2003 or Windows XP:  (Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Microsoft Dynamics NAV\ClientUserSetting.config)

Windows 7, Windows Vista, or Windows Server 2008 : (C:\Users\<username>\AppData\Local\Microsoft\Microsoft Dynamics NAV\ClientUserSetting.config)