domingo, 8 de noviembre de 2015

Increase the records number exported to Excel

With the following query you will obtein the maximun number of rows that can be exported to excel, you can used an "update" to change this value.

USE DATABASENAME_MSCRM

SELECT [Name], [MaxRecordsForExportToExcel]
FROM [dbo].[OrganizationBase]

 Remember that this number depends also of the limitation of your Microsoft office Excel. Dynamics CRM 2011 support excel: 2003 SP3, 2007 and 2010.

Excel version
Max. rows
2003
65,536
2007
1,048,576
2010
1,048,576

No hay comentarios: