Fix SharePoint Files Opening as Read-Only on One Computer
Question details
The user needs to fix an issue where SharePoint files (Word and Excel) are locked in read-only mode on one specific computer, despite working correctly on other devices.
- Product
- Microsoft Office (Word, Excel), SharePoint
- Device & OS
- Windows
- Scenario
- Accessing and editing shared documents hosted on SharePoint via local Office desktop applications.
- Observed behavior
- Files open strictly as read-only on a single computer regardless of the account used, while the exact same files are fully editable on a colleague's computer.
Ensure that your Office desktop applications are fully updated and verify that your account has the correct edit permissions for the SharePoint document library before making system-level changes.
Clear Stored Office Credentials in Windows
Removing corrupted local authentication data forces Microsoft Office to request fresh credentials from SharePoint, which typically resolves machine-specific read-only errors.
When local authentication tokens become corrupted, Office applications may fail to recognize your editing permissions, forcing files into read-only mode to prevent unauthorized changes.
Open Word or Excel, click on your profile picture or name at the top right corner, and select 'Sign out'. Close all running Office applications completely.
Click on the Windows Start menu, type 'Credential Manager' into the search bar, and press Enter to launch the utility.
Select the 'Windows Credentials' tab. Scroll down to the 'Generic Credentials' section, locate any entries starting with 'MicrosoftOffice', click the drop-down arrow next to them, and select 'Remove'.
Restart your computer. Open Microsoft Word or Excel, click 'Sign in', and enter your Microsoft 365 credentials to re-authenticate with SharePoint.
Check SharePoint Library Security Settings
If clearing credentials does not work, specific SharePoint site settings such as required check-outs might be restricting file access.
Clear Browser Cache and Use InPrivate Mode
Stale web browser data can sometimes interfere with the authentication token passed from SharePoint Online to your local Office apps.
Experience Hassle-Free Document Editing with WPS Office
If complex SharePoint permission errors and Office credential issues are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly alternative to smoothly handle all your daily document needs.
- 1. Download the software: Visit the official WPS website and download the free WPS Office installation package.
- 2. Install and launch: Run the installer to quickly set up WPS Office on your Windows computer.
- 3. Open and edit files: Right-click any downloaded Word or Excel document and choose 'Open with WPS Office' to begin editing immediately.
Frequently Asked Questions
Why are my SharePoint files only opening in read-only mode on one computer?
This typically happens when the stored local Office credentials in your Windows Credential Manager become corrupted. Because the issue is isolated to the local authentication cache on that specific machine, the files will still open and function normally on other computers.
How do I know if the read-only issue is caused by SharePoint or my local computer?
If you can edit the file on a colleague's computer or by using the Office web browser apps, but it opens as read-only on your desktop, the problem lies with your local computer's Office installation or stored account credentials.
Can checking out a file in SharePoint prevent read-only errors?
Yes, but only if the library is configured to require it. If 'Require Check Out' is enabled in the SharePoint library settings, you must manually check out the file before editing. Otherwise, the file will open in read-only mode to prevent conflicting changes.
