SAP Knowledge Base Article - Public

3000057 - Universal Change to Microsoft Excel XLSX Output for Report - Table & Report - Custom

Symptom

Previously, exports via Report - Table (formerly Ad Hoc) and Report – Custom were saved to your local environment in the XLS format.

During the Second Half 2020 Release, these exports will use the XLSX (Microsoft Excel 2007 and later) file format.

Environment

SAP SuccessFactors HXM suite

Reproducing the Issue

  • This behavior can be observed when running the report offline or exporting it:
  1. Execute the report in Report Center
  2. Select "Run Offline" or "Export"
  3. Select "Excel" option
  4. You'll notice that the output file extension is .xlsx

  • Or in scheduled reports:
  1. Create a New Schedule
  2. Under Report Format select Excel
  3. You'll notice that the output file extension is .xlsx

  • The Reports schedules previously created had their format changed to .xlsx as well

Cause

The next-generation XLSX was introduced in 2007 and is Microsoft Excel default format. Benefits include:

  • Efficiency

    XLSX delivers the same content within a smaller, more efficient file, benefiting both SAP SuccessFactors resources and your local environment.

  • Convenience
    For the majority of customers who utilize Microsoft Excel 2007+, using XLSX allows you to open the export without enabling Microsoft Excel’s compatibility mode

Resolution

This is the expected behavior after second half 2020 release. For further details please check our Community Post.

Keywords

XLS XLSX excel format extension adhoc table export , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HXM Suite all versions