SAP Knowledge Base Article - Preview

3065649 - Error: 'The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.' when opening a file generated by exporting a report containing hyperlink to MS Excel (XLSX) from Crystal Reports

Symptom

  • Unable to open a spreadsheet in MS Excel.
  • Error in MS Excel, when opening a report exported to MS Excel (XLSX) format, from Crystal Reports.
  • When opening a file in MS Excel, that was generated by exporting a report containing hyperlinks, to MS Excel (XLSX), from Crystal Reports, it generates the error:

         "Microsoft Excel
          We found a problem with some content in <file name.xlsx>. Do you want us to try recover as much as we can?
          If you trust the source of this workbook, click Yes”

    And when clicking "Yes", it displays the error:
        
         "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt."
      
        
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2020
        
  • MS Excel 2013
  • MS Excel 2016
  • MS Excel 2019 ( Office 365 )  

Product

SAP Crystal Reports 2020

Keywords

 CR, xport , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.