How to Increase the Maximum Records exported to Excel from CRM Dynamics

How to Increase the Maximum Records exported to Excel from CRM Dynamics

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:

  1. Open SQL      Mangement Studio
  2. Use the      <your organization>_MSCRM database
  3. Open the      OrganizationBase table
  4. Locate the      column  MaxRecordsForExportToExcel
  5. Run Update      Query to change the value to the new value

 1. Select MaxRecordsForExportToExcel From OrganizationBase

2. Update OrganizationBase

Set MaxRecordsForExportToExcel=50000

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 !!!

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *