2545430 - How to download / export Ad Hoc reports in XLSX format?

SAP Knowledge Base Article - Public

2545430 - How to download / export Ad Hoc reports in XLSX format?

Symptom

Ad Hoc report exports and downloads to Excel are currently of file extension XLS.
You would like to change it to XSLX (supported by MS Excel 2007 and later)

Environment

SuccessFactors Ad Hoc reporting

Reproducing the Issue

    1. Navigate to Ad Hoc Reporting
      Analytics> Reporting > Reports> Ad Hoc Reports

      For instances with Report Center, just navigate to Report Center

    2. Select any Ad Hoc report and Run it.

      Run_1.png

      For instances with Report Center, select any 'Report Table' and Run it.

      Run_2.png

    3. Export the Ad Hoc report's output:
      • Run Online and Export:

        Run_Online.png
        or
      • Run offline, choose Excel and download from Scheduled Reports  (My Jobs if Report Center has been enabled)
    4. The downloaded file is in '.xls' format.

Cause

Ad Hoc report exports will be in xlsx format only if the corresponding Provisioning switch is enabled.

Resolution

  1. Login to Provisioning and select the company under concern.
  2. Select Company settings.
  3. Search for and enable the below switch:

    "Generate Excel 2010 Output for Adhoc Reports"

    provisioning.png

    NOTE FOR CUSTOMERS: Please contact your Implementation partner or create a support incident to have the fix applied in Provisioning

Keywords

Ad Hoc export XLSX
AdHoc export XLSX
XLS XLSX
Microsoft Excel 2007 format
MS Excel 2007 format , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core all versions