Home Forums Reporting Services Reporting Services 2005 Development Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows. RE: Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows.
Bob Griffin
SSCertifiable
Points: 5982
More actions
January 8, 2009 at 2:13 pm
#923699
The excel limit is a hard limit. The only way to work around that is to summarize the data more in your select statement (group by) or select a smaller range of data in your parameters i.e. date range, from/to etc...