How to Increase the Maximum Records exported to Excel from CRM DynamicsUsman
In this post I am going to explain how we can increase maximum number of records that can be exported from CRM Dynamics 2011 to Excel spread sheet. By default maximum number of records can be exported are 10000 using the “Static worksheet with records from all pages in the current view” feature.
Even if you export more than 10,000 records, only first 10,000 records would be visible. It is quite hard to find exact number of records in this way. To increase this default parameter value you need to update MaxRecordsForExportToExcelcolumn in OrganizationBase. This can only be done in SQL Server management studio.
Please follow these steps:
- Open SQL Mangement Studio
- Use the <your organization>_MSCRM database
- Open the OrganizationBase table
- Locate the column MaxRecordsForExportToExcel
- Run Update Query to change the value to the new value
1. Select MaxRecordsForExportToExcel From OrganizationBase
2. Update OrganizationBase
In my case there is only one record in OrganizationBase table that’s why I didn’t write where condition. If you are having more than one organization records in this table, you should have to apply where condition to specify which oranization’s MaxRecordsForExportToExcel value you are changing, otherwise it will change for all organization’s MaxRecordsForExportToExcel value to 50,000.
If you like this post please click LIKE and visit my sponsors thanks !!!