'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix SharePoint Documents Opening Read-Only in Office Desktop Apps
Question details
Users with owner permissions are unable to edit checked-out SharePoint documents in desktop Office applications because the files open in read-only mode.
- Product
- SharePoint, OneDrive, Microsoft Office
- Device & OS
- not provided
- Scenario
- Attempting to edit checked-out SharePoint documents using desktop Office apps instead of the web browser.
- Observed behavior
- Documents open as read-only in local desktop applications, even though the user has full owner permissions and can edit the same files without issues in the web browser.
Verify that you have an active internet connection, your OneDrive client is up to date, and you are signed into your Office desktop apps with the correct Microsoft account.
Stop OneDrive Synchronization for the Affected Library
Use this method if your SharePoint document library has custom columns and is synchronized via OneDrive, which often forces desktop apps into read-only mode.
When a document library contains custom columns and is synced to your local machine using the OneDrive client, Microsoft Office desktop applications may default to read-only mode to prevent metadata conflicts. Stopping the sync and opening the file directly from the cloud usually resolves this.
Click on the OneDrive cloud icon in your system tray (Windows) or menu bar (Mac), click the gear icon, and select 'Settings'.
Navigate to the 'Account' tab in the settings menu. Locate the specific SharePoint document library that is currently syncing and click 'Stop sync'.
Open your web browser and navigate to the SharePoint document library. Locate the document you want to edit, click the three dots (More actions), and choose 'Open in Desktop App' to test if editing is now available.
Review SharePoint and Group Permissions
Check for overlapping or conflicting access settings if stopping OneDrive synchronization does not resolve the read-only issue.
Try WPS Office for Seamless Document Editing
If you are frustrated with complex sync issues, custom column conflicts, and read-only limitations in Microsoft Office, consider switching to WPS Office. It provides a lightweight, free, and highly compatible suite for all your document needs without the hassle of intricate server permission errors.
- 1. Download and Install: Get the free WPS Office installer from the official website and complete the quick installation process.
- 2. Open Your Documents: Launch WPS Office and open your Word, Excel, or PowerPoint files directly from your local drive or preferred cloud storage.
- 3. Edit Without Restrictions: Enjoy full editing capabilities without unexpected read-only limitations or sync-related lockouts.
Frequently Asked Questions
Why can I edit the document in the browser but not in the desktop app?
Web browsers edit documents directly on the SharePoint server, bypassing local sync clients. Desktop apps often rely on OneDrive synchronization, which can lock files as read-only if there are custom columns, missing metadata, or local sync conflicts.
Does checking out a document guarantee I can edit it?
Not necessarily. Checking out a document reserves it for you on the server, but local application issues, such as OneDrive sync errors or conflicting group permissions, can still force the desktop app to open the file in read-only mode.
How do custom columns in SharePoint affect Office desktop apps?
Custom columns require specific metadata to be filled out. When a library is synced to your PC through the OneDrive client, the desktop app may restrict editing (setting it to read-only) to prevent the required metadata from being corrupted or bypassed.
Can clearing the Office cache fix read-only issues?
Yes. Sometimes outdated cached files cause conflicts with SharePoint permissions. You can clear the cache by opening the Office Upload Center (or Office Document Cache settings) and selecting the option to delete cached files.
