Tuesday, July 15, 2014

Export to Excel Limitation in CRM




One limitation that every CRM user would have come across is the limitation in the number of rows while exporting to excel . But luckily there is a way to fix this..

Modify Max Export Tool      Download here

This tool is used to increase the maxrecordsforexporttoexcel value. maxrecordsforexporttoexcel represents the maximum number of records that will be exported to a static Microsoft Office Excel worksheet when exporting from the grid.

Requirements:


  • .Net 4.0 
  • Windows Identity Foundation (WIF) 
  • Windows 8 - Control Panel, Programs, Turn windows features on or off, select the box for Windows Identity Foundation 3.5, OK. 
  • Windows 7\Vista\Servers 
  • WIF is not supported in Windows XP 


Usage:
1. Extract ModifyMaxExportAllDeploymentsTool.zip and double click ModifyMaxExportAllDeploymentsTool.exe to run.

2. Follow the prompts and provide deployment information when asked. The information required depends on deployment type (Online or On Premises) and whether or not the tool has been run before. The deployment information will be saved for the next time the tool is run.
3. You will be shown the current maxrecordsforexporttoexcel value and asked if you want to change it.
4. If you choose to change it you will see the following.
5. On successful update the following message will show