Fix Excel SharePoint File Not Saving Changes for One User
Question details
A specific user is unable to check out or save changes to an Excel document in a SharePoint library, while other users can do so without issues.
- Product
- Microsoft Excel / SharePoint
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel file in SharePoint that has the 'require check-out' setting enabled.
- Observed behavior
- The affected user can open and edit the document, but the check-out option is missing, and any modifications they make fail to save.
Ensure the affected user is logged into the correct Microsoft 365 account with an active subscription, and verify that no one else currently has the document checked out.
Verify and Restore User Permissions in SharePoint
Check if the user's permissions for the document or the entire SharePoint library have been altered or restricted.
In SharePoint, document permissions can be inherited from the library or set uniquely for individual files. If a user's 'Edit' access is downgraded or removed, they will lose the ability to check out and save changes.
Open the SharePoint site as an administrator and go to the Document Library containing the affected Excel file.
Click the Gear icon in the top right corner and select 'Library settings', then click 'More library settings'.
Click on 'Permissions for this document library' and use the 'Check Permissions' button in the ribbon. Enter the affected user's name to see their current permission level.
If the user lacks 'Edit' or 'Contribute' access, use 'Grant Permissions' to restore their rights so they can check out and edit documents.
Clear Browser Cache and Cookies
Resolve corrupted local browser data that might be preventing the SharePoint interface and check-out options from loading correctly.
Re-authenticate the Office Desktop Application
Fix synchronization or authentication glitches within the Excel desktop app by signing out and signing back in.
Try WPS Office for Seamless Team Collaboration
If you frequently encounter complex check-out, permission, and sync issues with Microsoft Office and SharePoint, consider switching to WPS Office. It provides a lightweight, reliable environment for managing spreadsheets with robust cloud integration.
- 1. Download the Installer: Visit the official WPS website to download the free WPS Office installer for your device.
- 2. Install and Launch: Run the setup file and follow the on-screen instructions to install the suite. Open WPS Office once completed.
- 3. Collaborate Instantly: Sign in with your email to activate WPS Cloud, open your existing Excel files, and start collaborating without complicated check-out restrictions.
Frequently Asked Questions
Why does only one user lose the check-out option in SharePoint?
This usually happens if that specific user's access level was downgraded to 'Read-only', if their browser has corrupted cache data blocking SharePoint scripts, or if there is a synchronization error specifically tied to their Microsoft 365 account session.
Can a browser issue cause SharePoint Excel files to not save?
Yes. Outdated browser cache, blocked third-party cookies, or incompatible extensions can disrupt the connection between Excel for the Web and SharePoint, preventing changes from saving or the check-out button from rendering.
How do I check a user's permission level in a SharePoint library?
As a site admin, go to Library Settings > More library settings > Permissions for this document library. Use the 'Check Permissions' button in the ribbon, enter the user's name, and it will display their exact permission levels and how they are inherited.
