1456919 - Error; Excel found unreadable content... when exporting to Excel file format

SAP Knowledge Base Article - Public

1456919 - Error; Excel found unreadable content... when exporting to Excel file format

Symptom

  • The report has in excess of 6,000 rows
  • Exporting to Excel format appears to be successful
  • Opening the exported file in Excel results in the error;
Excel found unreadable content in name_of_file.xls. Do you want to recover the contents of this workbook?
  • Allowing "recover the contents of this workbook", results in all formatting being removed from the xls file
  • Report with less rows exports correctly

Cause

  • The report had a New Page After option on the detail section enabled
  • This resulted in an xls file that had too many pages for Excel
  • For limits of Excel files, see the Microsoft Office Online documentation; Excel specifications and limits

Resolution

  • Filter the report data for smaller result set
  • Remove the  New Page After option
  • Export to a different format
  • Note. The number of rows is not the defining variable, number of pages generated is

Keywords

Forum thread , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2