Symptom
When a table report is exported in Excel format, it is downloaded as a Microsoft Excel 97-2003 worksheet (.xls) instead of the newer Microsoft Excel worksheet (.xlsx).
Environment
- SAP SuccessFactors HCM Suite
- SAP SF People Analytics
Reproducing the Issue
- Go to report center.
- Create/Run table report.
- Export the report in Excel format.
- The report will get downloaded in Microsoft Excel 97-2003 worksheet.
Cause
Necessary toggle needs to be disabled for the instance.
Resolution
Please reach out to SF Support Team in order to opt out the necessary toggle for the instance under component (LOD-SF-ANA).
Keywords
Table, export, adhoc, report, excel, xls, xlsx, worksheet, Excel 97-2003 worksheet , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-EXP , Report Exports (Ad Hoc, YouCalc, ORD) , Problem
Product
SAP SuccessFactors HCM Core 2505
SAP Knowledge Base Article - Public