Fix SharePoint Excel Files Not Showing Other Users' Changes
Question details
Users are unable to see rows or modifications added by other collaborators in shared SharePoint or OneDrive Excel workbooks.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on shared Excel workbooks via a web browser or the desktop app.
- Observed behavior
- Your own changes save and display correctly, but modifications and new rows added by other users fail to appear in the document.
Ensure that you have a stable internet connection and that all collaborators are logged into the correct Microsoft 365 accounts with editing permissions for the document.
Verify SharePoint Document Library Permissions
Ensure that all collaborators have the appropriate editing permissions and that the file is stored in a standard, properly configured document library.
Sometimes synchronization issues occur because users lack full editing permissions at the folder level, or the file is stored in a library with custom checkout requirements.
Navigate to the SharePoint document library where the Excel file is stored. Click the ellipsis (...) next to the file or folder and select 'Manage Access'.
Review the list of users and groups. Ensure that the collaborators trying to add rows have 'Can edit' permissions rather than 'Can view'.
Create a brand new test folder directly in the root of the SharePoint document library. Move the Excel file there to see if the syncing issue is isolated to a specific subfolder's corrupted permissions.

Allow Time for Server Synchronization
SharePoint and OneDrive can occasionally experience temporary backend synchronization delays that resolve themselves automatically.
Try WPS Office for Seamless Real-Time Collaboration
If SharePoint synchronization issues continue to disrupt your team's workflow, consider switching to WPS Office. It provides a free, lightweight alternative to Microsoft Office with robust real-time co-editing capabilities and reliable cloud synchronization.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your PC, Mac, or mobile device.
- 2. Upload to WPS Cloud: Sign in to your free WPS account and upload your existing spreadsheets to WPS Cloud.
- 3. Invite Collaborators: Click the 'Share' button in the top right corner to generate an editing link, allowing your team to start co-authoring instantly.

Frequently Asked Questions
Why do my Excel formulas calculate differently than what other users see in SharePoint?
Calculation differences can occur if users have different calculation options set locally (e.g., Manual vs. Automatic) or if there is a synchronization delay in the co-authoring session preventing the latest data from being factored into the formula.
Does clearing the Office cache help with SharePoint sync issues?
Yes, clearing the Office Document Cache can resolve local sync conflicts that prevent other users' changes from downloading to your local Excel desktop app. You can do this via the Office Upload Center or Excel's Save settings.
Can locked cells prevent me from seeing others' changes in real-time?
If another user is actively editing a specific cell or range, that section is temporarily locked for them to prevent conflicting edits. Once they press Enter or click away, the file syncs and you will be able to see their changes.




