The workbook cannot be opened or we are sorry, we couldn’t open your workbook.

The workbook cannot be opened  or we are sorry, we couldn’t open your workbook.

Issue: We are sorry we could not open your work book or sorry, but to open this workbook your computer must be running a supported version of Microsoft excel

Solutions: there could be many reasons of the issue. I am providing the solution for the  most common.

Error: We are sorry we could not open your work book

 

 

You can use following cmdlets to get this issue resolved

$webApplication = Get-SPWebApplication –Identity <URL of the Web application>

$webApplication.GrantAccessToProcessIdentity("<insert service account>")

Error: We're sorry, we couldn't open your workbook. It is possibly corrupt or using a file format that's not supported. Do you want to try and open this file in excel?" as shown in below image

1.   Download the file to local system and open it in excel. If it does not open correctly then you can say it is  corrupt and need to be changed.

2.   If it opens correctly then nothing is wrong with file, you have to check for other resolution.

·        it might be the reason that  not started Excel web service on all your web front end servers. Once you start the excel web service on all your web front end servers. This issue will be gone

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.