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

• 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.

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

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