Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

When you export records from CRM 3.0 to Microsoft Excel only the first 10,000 rows are exported.  Unless you scroll to the end of the spreadsheet there isn't any kind of indication that a limit has been reached.  The following post from Microsoft walks you through the steps necessary to increase the limit.

http://support.microsoft.com/kb/911395/enus$

To change this in CRM 4.0:

1. Log-in to the SQL Server where the <Organization_Name>_MSCRM database is stored
2. Open the OrganizationBase table
3. FInd the Column:  MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
5. Committ the change to the database

- Jeremy 

** This posting is provided "AS IS" with no warranties, and confers no rights.

Published 06-18-2008 1:47 PM by Jeremy Winchell

Comments

# re: Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

Wednesday, September 10, 2008 11:37 AM by Chris

This doesn't work in 4.0

On MS site, they tell you to submit a support request...

# re: Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

Monday, September 15, 2008 2:51 PM by Jeremy Winchell

I have gotten this to work without an issue in 4.0.  However, I did have to extend the SQL Timeout but we were trying to export 50,000 rows.

# re: Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

Friday, October 03, 2008 3:48 PM by Craig Kozak

Don't forget about the iisreset too ;)

# re: Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

Wednesday, October 22, 2008 7:21 PM by Jeremy Winchell

Ah, yes thanks for that reminder Craig.  I will be sure to put that in the post.

Jeremy