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.

To change this in CRM 4.0:
1. Log-in to the SQL Server where the _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

yep.. there’s no limit.. but the records we are trying to export is more than 10000 and have lots of columns included. Aside from taking too much time in extraction, a dialog box appeared saying that an error has occurred after waiting for 5 mins or so.

I have tried exporting those data by lessening the number of columns and the extraction worked. So that means that the problem is having too many columns 😦

Do you think that the problem is a timeout error? Because it’s taking too long?