SAP Knowledge Base Article - Public

2576356 - Excel cannot open the file '.xlsx' because the file format or file extension is not valid

Symptom

You are facing following error when "double click" to open file downloaded from SuccessFactors report with Excel version 2007 or above.
Excel cannot open the file '.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

error.png

Excel shows an empty screen after you click Button "OK".

Environment

  • SAP SuccessFactors HCM Core
  • Ad Hoc Report

Reproducing the Issue

  1. Analytics/Reports > Ad Hoc reports > Export a or Schedule a report as Excel  
  2. Open the Excel file just saved
  3. Error message occur before opening the file
    Excel cannot open the file '.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
  4. Click ok , then the file opened is empty

Cause

This error occur when you are using Excel 2010 or higher.

Resolution

To solve this issue for Ad Hoc reports make sure the option Generate Excel 2010 Output for Adhoc Reports is checked as follow:

From Provisioning > Company Settings > Analytics and Dashboard Tabs & Misc Reporting > Generate Excel 2010 Output for Adhoc Reports

As a workaround you can:

  • Save the file first, on your desktop, then open it
    or  
  • Run the report offline as csv format as shown below:
    run report offline csv.png

 

Keywords

Excel cannot open the file, file format or file extension is not valid, The file you are trying to open, different format than specified by the file extension, list, local file, spreadsheet, xls, xlsx, office 2003, 2007, 2010, ad hoc report , KBA , LOD-SF-ANA-EXP , Exports , Problem

Product

SAP SuccessFactors HCM Core 1711