CRM 3.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
CRM 4.0
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
Hi
I did these things.. but unfortunately, it didn’t work. We might be able to extract more than 10000 records but I think the problem here is the Number of Columns. Should there be any limit?
there is no limit on columns, it might just take more time if you add all column but it should work…
what error are you getting??
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?
Yes, try increasing your sql time out as mentioned in following article
http://mayankp.wordpress.com/2010/05/24/crm-4-0-time-out-issue/
Hello,
Thank you for your reply. Will try to work on it and see if this works.
Thank you very much