SAP Knowledge Base Article - Public

2897072 - Error happens when opening excel file which is exported from story in SAP Analytics Cloud (SAC)

Symptom

Error below happens when opening excel file which is exported from story in SAC.

We found a problem with some content in 'XXX.xlsx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Create model based on Excel file.
  2. Create story based on the model.
  3. Add calculated measure to the story and set the scale of the measure as Percentage.
  4. Export the story to XLSX Excel file, check Include Formatting option.
  5. Open the exported excel file, error below happens.

    We found a problem with some content in 'XXX.xlsx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Cause

This issue is a product defect.

Resolution

This issue will be fixed in wave 2020.07.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, excel, xlsx, format, formatting, percent, percentage, include, scale, calculation, measure , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0