FIX: SharePoint won’t open Excel or Word documents

4 minute read

Home » Fix » FIX: SharePoint won’t open Excel or Word documents

SharePoint is a handy collaborative platform from which users can usually open MS Office documents.

However, a few SP users have stated in forums that they can’t open Word or Excel documents in SharePoint document libraries. Documents don’t open when they select to open them with client MS Office software from within SP.

Here are a few resolutions that might fix SharePoint issues for opening Excel or Word documents.

What to do if SharePoint won’t open Excel/ Word files

  1. Turn Off Protected View
  2. Restore Advanced Settings to Default
  3. Repair a Corrupted File
  4. Open SharePoint in Internet Explorer 11
  5. Check Your Office Account

We’ve written extensively about SharePoint issues before. Bookmark this page in case you need it later.


Turn Off Protected View

It might be the case that Protected View is blocking the document opening. When that happens, a “Word experienced an error trying to open the file” error message pops up or the document might hang.

To fix that, you can turn off Protected View for MS Office applications as follows.

  • Open the Word or Excel application.
  • Click the File tab.
  • Select Options to open the window shown directly below.

  • Click Trust Center on the left of the window.
  • Press the Trust Center Settings button to open further options.
  • Click Protected View on the left of the Trust Center window.

  • Then deselect all the Enable Protected View settings, and press the OK button.

Restore Advanced Settings to Default

  • Some users have confirmed that restoring advanced net settings can fix Office documents not opening from SharePoint libraries. To do that, open Cortana’s search box by clicking the Type here to search button.
  • Enter the keyword ‘internet’ the search box, and select to open Internet Options.
  • Select the Advanced tab in the snapshot directly below.

  • Press the Restore advanced settings button.
  • Then click the Apply and OK buttons.
  • Restart your laptop or desktop.

Repair a Corrupted File

Your Excel or Word file might be corrupted. If so, then you’ll need to repair the file to open it. This is how you can repair a corrupted Office document.

  • To check if a file is corrupted, download it from SharePoint by clicking the Download option. Then try opening it from Word or Excel from the C: drive folder you saved it to.
  • If you still can’t open the document, you can fix it with the Open and Repair recovery option in MS Office applications. Click the File tab and select Open to open the window in the snapshot below.

  • Select the corrupted file with a single click.
  • Click the small arrow on the right of the Open button to expand the menu shown directly below.

  • Select the Open and Repair option on the drop-down menu.
  • Alternatively, you can repair a corrupted MS Word document by opening this page, pressing the Choose file button to select document and then clicking the Secure Upload and Repair option.
  • To repair an Excel document, open this webpage in a browser. Click Choose file to select the Excel document, and press the Secure Upload and Repair button.

Repair corrupted files in no time with these great tools!


Open SharePoint in Internet Explorer 11

If you’re utilizing SharePoint within Google Chrome, Edge or Firefox, consider switching to Internet Explorer 11 instead.

The 32-bit Internet Explorer is the most compatible browser with SharePoint as it fully supports ActiveX controls. ActiveX is essential for launching documents in earlier SharePoint versions.

So try opening a Word or Excel file from a SharePoint document library within IE. You can launch Internet Explorer by entering the keyword ‘IE’ in Cortana’s search box.

Check Your Office Account

Note that your SharePoint account should match your MS Office client account. If you’re using different accounts for SharePoint and MS Office, that might be why SP doesn’t open Excel and Word files.

Some users have stated that they needed to add their SharePoint Online accounts again after renewing MS Office subscriptions. This is how you can check, and change, your MS Office account.

  • Open the MS Word or Excel client application.
  • Click the user account name at the top left of the window.
  • Then click Sign out.
  • Select an alternative account to sign in with if there is one. Sign in with an account that matches the one you’re utilizing in SharePoint.
  • Alternatively, you might need to add a SharePoint account by clicking Add Account. Enter your SharePoint account details, and press the Sign in button.

Those are some of the resolutions that might fix SharePoint so that you can open Word and Excel files directly from its document libraries again.

Also make sure that your browser includes SharePoint Online within its trusted sites. If you have discovered another fix for SharePoint not opening MS Office documents, feel free to share it below.

RELATED STORIES TO CHECK OUT:

Discussions

Next up

Not enough physical memory error in VMware [FULL FIX]

Rabia Noureen avatar. By: Rabia Noureen
2 minute read

A large number of VMware users have reported encountering the following error message: Not enough physical memory is available to power this virtual machine with […]

Continue Reading

Troubles with your Uplay login? Here’s what you can do

John Taylor avatar. By: John Taylor
2 minute read

Some users have reported that they are having problems when trying to log in their Uplay client. Apparently, they receive an error message that looks […]

Continue Reading

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading