Excel is not responding
SSRS 2008 R2. I have a report that is saved as Excel. The size of the excel report is 3MB. It's a multi sheet report and i used the pagename property in SSRS to name excel sheets. I was able to export and save the report as Excel but opening the report is not possible. Excel stops responding. Did anyone face similar problem? Any help please! Thanks. Update: I tired remove the page breaks and the page name. It doesn't work either. Is there any limitation as is the size or the # of rows when exporting to excel. Is this a bug?
November 9th, 2010 9:19pm

Hi, There are limitations on reports that are exported to Microsoft Excel. The most significant are the following: Support for Microsoft ActiveX controls is not provided. The maximum number of rows in Excel is 65536. This is checked by the rendering extension, and an error is displayed in Excel if the limit is exceeded. The maximum number of columns in Excel is 256. This is checked by the rendering extension, and an error is displayed in Excel if the limit is exceeded. The maximum column width in Excel is 255 characters or 1726.5 points. This is not checked by the rendering extension. The maximum number of characters in a cell is 32767. This is not checked by the rendering extension. There is a limit to the number of worksheets that Excel can have per workbook. Each section in the HTML becomes a worksheet; if the report is large and exceeds the number of worksheets, an error is displayed in Excel if the limit is exceeded. Excel supports only the following border line widths: 0.5 pt., 1.0 pt., and 1.5 pt. The maximum number of levels for nested outlines is 7. Multiple newsletter-style columns in the report body are not supported by the Excel rendering extension. All reports are rendered within a single column by the Excel rendering extension. Top and bottom padding in text boxes is always ignored when the report is rendered in Excel. Please have a check to see whether these limitations you have encountered, thanks. Challen Fu
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2010 3:12am

Hi, I have hit this restriction also on an export to excel 2007. Is there a work around for this or will it be fixed in future releases of ssrs? thanks J
November 15th, 2010 12:08pm

Thanks Challen! This is useful information.
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 8:33pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics