SAP Knowledge Base Article - Preview

1271035 - Error: 'Excel encountered an error and had to remove some formatting...' when opening a report exported to MS Excel from Crystal Reports

Symptom

  • Error when opening a document in MS Excel.
  • Report exported from Crystal Reports to MS Excel generates an error when open in MS Excel. 
  • When opening a report exported to MS Excel format from Crystal Reports, it generates the error:
        
     'Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully.'


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

MS Excel, Crystal Reports, CR, Excel, Export , 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.