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

Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows

INTRODUCTION

This article describes how to change the maximum number of records that you can export from Microsoft Dynamics CRM to a Microsoft Office Excel worksheet when you use the "Static worksheet with records from all pages in the current view" feature.

More Information

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:

https://mbs.microsoft.com/support/newstart.aspxYou can also contact Technical Support for Microsoft Dynamics by telephone at (888) 477-7877.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×