Wednesday, February 23, 2011

Increase the Maximum Records exported to Excel in CRM 2011

some times you needs to export more than 10000 records from CRM to reimport it back into other environment. But default CRM supports upto 10000 records while exporting crm records into Excel.
Follow the steps below to make the change at the database level in CRM 2011/4.0 to extend the limitation.

  • Open SQL Mangement Studio
  • Use the <organization>_MSCRM database
  • Open the OrganizationBase table
  • Locate the column – MaxRecordsForExportToExcel
  • Change the value to the new value, to which extent you wants to increase.
Thats it, now you can export data to your wish. No limitation... :)

"My best friend is the one who brings out the best in me."
- Henry Ford

No comments:

Post a Comment