SAP Knowledge Base Article - Public

2909341 - Error happens when opening excel file that 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. Select Scale as Billion and make the value in story displayed as +0.
  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 caused by product bug.

Resolution

This issue will be fixed in 2020.08 version.

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-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0