SAP Knowledge Base Article - Public

3047217 - Error happens when opening excel file that exported from story in SAP Analytics Cloud (SAC) if EXCEL has Office authoring languages and proofing set to Japanese

Symptom

When export a table in special story in SAC into xlsx format, if the EXCEL language option has setting Office authoring languages and proofing was set to Japanese, then open this xlsx file will have the warning error message below:

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

Environment

  • SAP Analytics Cloud (Enterprise) 2021.8

Reproducing the Issue

  1. In SAP Analytics Cloud, open the problematic story.
  2. Select the problematic table and export it to EXCEL (xlsx) format.
  3. In EXCEL, first go to Options -> Language, set Office authoring languages and proofing  to Japanese. And restart EXCEL
  4. Now open the downloaded xlsx
  5. Notice warning comes as
    We found a problem with some content in 'XXXXX.xlsx'. Do you want us to try to recover as much as we can? If you trust this source of this workbook, click Yes.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Bug Filed

Product

SAP Analytics Cloud 1.0