Error Accessing Excel Report in Excel Web App

Recently we ran into issue where we were getting below error while accessing report in Excel Web App.

Error: “We’re sorry, we couldn’t open your workbook.
It’s possibly corrupt or using a file format that’s not supported.
Do you want to try and open this file in excel?”

Looking at the above error, it was clear that this issue is not related to excel services or secure store and something is wrong at the file level. Finally we found that it’s a know issue in Excel 2013 and to fix it we need to follow below steps.

  1. Open Report is Excel client
  2. Right click on Pivot table >> Properties
  3. Click on “Display” Tab and uncheck the below properties.
    • Show Contextual tooltip
    • Show Properties in tooltip
  4. Save the changes.