Sorry, we couldn’t open .xlsx file – Excel error

We had one user constantly having issues while opening Office documents stored in SharePoint site. Sorry, we couldn’t open ‘http://sharepointsite/sites/teams/documents/report.xlsx’ file. Even though it is one user, he had issues with multiple office files.

Sorry, we couldn't open
Sorry, we couldn’t open http://sharepoint/sites/documents/report.xlsx’ file

We tried with user logging into another machine and try accessing the file. As expected, all the files open fine. This makes it clear that there is some issue with users Office installation in his laptop.

First thing, I checked, which usually always works for me was ‘whether there were multiple office versions installed in users machine‘? This is not the case this time. Only Office 2013 was installed.

Before, kicking of  Office 2013 installation ‘Repair‘, I tried to clear the Document Cache. BAM! that fixed the issue. It turns out that user had corrupted office cache files. There can be many reasons for this error, but this fixed it for me.

Resolution:
  • Close all Office applications.
  • Clear all the files located under %systemDrive%\Users\%userprofile%\AppData\Local\Microsoft\Office\15.0\OfficeFileCache\

Note: [It’s okay, if you cannot delete one or two files]

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Designer cannot display the item

You run into ‘SharePoint Designer cannot display the item’ error when you are trying to edit an existing workflow setup in Designer quite often when there is a windows update or update to .NET framework installed in your computer. In some cases it may also not allow you to create new workflows. Resolution: Clearing Designer […]

Read More

Windows security prompt. Connecting to SharePoint….

Users often run into this issue. Windows security prompt pops up every 15 minutes or so repeatedly trying to connect to SharePoint. No matter you enter credentials or cancel, user will be prompted for credentials again and again. SharePoint may not be the culprit all the time. List of things I check whenever I run […]

Read More

User with Contribute access gets access denied

Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions – check permission option. Every other person in the […]

Read More