Microsoft KB Archive/911395

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

Article ID: 911395

Article Last Modified on 1/7/2008

-

APPLIES TO


 * Microsoft Dynamics CRM 4.0
 * Microsoft Dynamics CRM 3.0

-



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 XP and Windows Vista



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 &quot;Static worksheet with records from all pages in the current view&quot; 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 &quot;Static worksheet with records from all pages in the current view&quot; 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, 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:  Log on to the Microsoft Dynamics CRM 3.0 server as a user who has Write permissions for the following registry subkey:

 Click Start, click Run, type regedit, and then click OK. In Registry Editor, locate and then click the following registry subkey:

 On the Edit menu, point to New, click DWORD Value, type maxrecordsforexporttoexcel, and then press ENTER. Double-click maxrecordsforexporttoexcel, click Decimal, type the maximum number of records that you want to export to an Excel worksheet, and then click OK. Close Registry Editor.</ol>

Microsoft Dynamics CRM 4.0
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.aspx

You can also contact Technical Support for Microsoft Dynamics by telephone at (888) 477-7877.

Additional query words: crm crm30 crm3.0

Keywords: kbmbscrm40 kbhowto kbinfo kbmbsmigrate KB911395

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.