FIX: SharePoint won’t open Excel or Word documents

Matthew Adams By: Matthew Adams
4 minute read

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patented Technologies (requires upgrade).

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

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.

— RELATED: Fix: “Sorry, something went wrong” error in SharePoint 2013

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.

  • For various PC problems, we recommend this tool.

    This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

    1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
    2. Click “Start Scan” to find Windows issues that could be causing PC problems.
    3. Click “Repair All” to fix all issues with Patented Technologies (requires upgrade).

  • 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.

— RELATED: We’re sorry, sign-in isn’t working right now [Fix SharePoint error]

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:

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patented Technologies (requires upgrade).

Discussions

Next up

Surface Pro 3 gets new security updates, install goes smoothly

Giles Ensor avatar. By: Giles Ensor
2 minute read

After recent bad news stories about updates released by Microsoft for Windows 10, that you can read here and here, it is refreshing to read (or […]

Continue Reading

Best Windows 10 antivirus software to use in 2018

Radu Tyrsina By: Radu Tyrsina
7 minute read

Update – 2018 will soon come to an end and we already have a guide on what is the best antivirus you should get in […]

Continue Reading

These features are out for good with Windows 10 version 1809

Sovan Mandal avatar. By: Sovan Mandal
2 minute read

Microsoft is all set to launch its next big update, Windows 10 version 1809 in October. While that should be a nice piece of news […]

Continue Reading