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.

  • January 8, 2009 at 2:59 pm

    #923746

    In your table, try creating a group (outside of any current grouping you have) with no header or footer, and the page break after value set to true. For the grouping value, use an expression similar to

    =ROWNUMBER(Nothing) MOD 60000

    This should force a page break after 60000 rows of data, which will translate into a new excel tab when you export. I believe the 65K limit in Excel is on a per worksheet basis.