How to change the maximum number of records that you can export from Microsoft Dynamics CRM to a Microsoft Office Excel worksheet

By default, you can export a maximum of 10,000 records from Microsoft Dynamics CRM to an Excel worksheet by using the "Static worksheet with records from all pages in the current view" feature.

If you export more than 10,000 records, only the first 10,000 records are exported. You do not receive a warning message that lets you know that only the first 10,000 records were exported.



However, you can change the maximum number of records that can be exported from Microsoft Dynamics CRM to an Excel worksheet. In Microsoft Dynamics CRM 3.0, you can change the maximum number of records by changing a registry subkey. In Microsoft Dynamics CRM 4.0 and Microsoft Dynamics CRM 2011, you can change the maximum number of records by changing a database value.

Microsoft Dynamics CRM 3.0

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To do this, follow these steps:

1. Log on to the Microsoft Dynamics CRM 3.0 server as a user who has Write permissions for the following registry subkey:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
2. Click Start, click Run, type regedit, and then click OK.
3. In Registry Editor, locate and then click the following registry subkey:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
4. On the Edit menu, point to New, click DWORD Value, type maxrecordsforexporttoexcel, and then press ENTER.
5. Double-click maxrecordsforexporttoexcel, click Decimal, type the maximum number of records that you want to export to an Excel worksheet, and then click OK.
6. Close Registry Editor.
   

Microsoft Dynamics CRM 4.0 and Microsoft Dynamics CRM 2011

Contact Technical Support for Microsoft Dynamics. Log on to the Technical Support site for Microsoft Dynamics, and then create a new support request. To do this, visit the following Microsoft Web site: You can also contact Technical Support for Microsoft Dynamics by telephone at (888) 477-7877.