sharepoint

SharePoint File Open Errors

Resolution Checklist

  • 1 Understand SharePoint File Open Errors
  • 2 Clear local Office Document Cache
  • 3 Resolve Windows Office Client Open Errors
  • 4 Resolve macOS Office Client Open Errors
  • 5 Summary Checklist for File Open Errors

SharePoint File Open Errors

When attempting to open files from a synced SharePoint library or via SharePoint Online web links, Microsoft Office applications can fail, displaying error messages such as “We couldn’t open this file”, “Word experienced an error trying to open the file”, or “This document is locked for editing by another user”.

This guide outlines the causes of SharePoint file opening errors and provides troubleshooting instructions to purge corrupted local document caches on Windows and macOS.

1. Understand SharePoint File Open Errors

File opening issues in SharePoint are typically linked to local cache conflicts, authentication mismatches, or system locks:

  • Corrupt Office File Cache: Microsoft Office desktop apps maintain an independent local cache directory (OfficeFileCache). If a sync gets interrupted, the cache index corrupts, preventing Office from opening the server-side file.
  • Account Authorization Mismatch: If the active user profile logged into your Word/Excel application differs from the Microsoft Account authorized on the SharePoint site, the file load will be rejected.
  • OneDrive Handle Lock: The OneDrive sync client can occasionally hold an exclusive OS read/write handle on a file during synchronization, blocking Microsoft Office from opening it.
  • Browser File-Association Corruption: Stale file associations or browser extensions can block the deep-link handlers (e.g., ms-word://) that launch desktop apps from SharePoint links.

2. Clear local Office Document Cache

The most common fix for file open failures is resetting the Office Upload Center cache.

Windows Steps:

  1. Close all Office applications.
  2. Open the Start menu, type Office Upload Center (or Microsoft Office Details).
  3. Go to Settings and click Delete cached files.
  4. Confirm the deletion when prompted.

3. Resolve Windows Office Client Open Errors

If deleting the cache via the UI fails or is unavailable, use the command line to force close processes and purge the directories.

Step 1: Force Close OneDrive and Office Apps

Run this command in an elevated Command Prompt to close locked application handles:

taskkill /f /im OneDrive.exe /im winword.exe /im excel.exe /im powerpnt.exe /im officeclicktorun.exe /im MSOSYNC.EXE

Step 2: Delete Cached Office Directories

Purge the local cache and temporary Office directory:

:: Delete the Office File Cache folder
rmdir /s /q "%localappdata%\Microsoft\Office\16.0\OfficeFileCache"

:: Delete the Office Web Cache folder
rmdir /s /q "%localappdata%\Microsoft\Office\16.0\WebServiceCache"

Step 3: Run the OneDrive Reset Command

Force OneDrive to rebuild its file index and unlock files:

"%localappdata%\Microsoft\OneDrive\onedrive.exe" /reset

4. Resolve macOS Office Client Open Errors

On macOS, you must clear the Microsoft containers and caches to remove corrupted file lock states.

Step 1: Force Close macOS Office and Sync Processes

Open Terminal and terminate the applications:

killall OneDrive
killall "Microsoft Word" "Microsoft Excel" "Microsoft PowerPoint"

Step 2: Delete Corrupt Office Caches on macOS

Purge the caching directories for each Office desktop application:

# Delete Word Caches
rm -rf ~/Library/Containers/com.microsoft.Word/Data/Library/Caches
rm -rf ~/Library/Containers/com.microsoft.Word/Data/Library/Application\ Support/Microsoft/Office

# Delete Excel Caches
rm -rf ~/Library/Containers/com.microsoft.Excel/Data/Library/Caches

# Delete PowerPoint Caches
rm -rf ~/Library/Containers/com.microsoft.Powerpoint/Data/Library/Caches

# Purge Office Web Service Cache
rm -rf ~/Library/Containers/com.microsoft.Office365ServiceV2

Step 3: Clear Keychains for Microsoft Accounts

  1. Launch Keychain Access (via Spotlight).
  2. Search for Microsoft Office and delete all password entries.
  3. Relaunch your Office apps and sign back in to establish a clean authentication token.

5. Summary Checklist for File Open Errors

Troubleshooting AreaRoot CauseActionable Resolution
Active App LockOneDrive or Office holding lockTerminate applications via Command Prompt/Terminal.
Windows CacheCorrupt local cache databaseDelete %localappdata%\Microsoft\Office\16.0\OfficeFileCache.
macOS CacheStale container statesPurge ~/Library/Containers/com.microsoft.* folders.
Identity MismatchIncorrect account active in OfficeLog out of all accounts in Word/Excel and sign back in with corporate credentials.
Redirect HandlersWeb browser fails to open desktop appClear browser cookies for sharepoint.com or use a private window.
Sync Syncing LoopsStuck OneDrive file synchronizationReset the OneDrive client (/reset cmd on Windows or standalone on Mac).