SharePoint Document Issues

Fix SharePoint Excel Files Not Showing Other Users' Changes

Camila MilosovichCamila Milosovich Oct 23, 2026 869 views

Question details

Users are unable to see rows or modifications added by other collaborators in shared SharePoint or OneDrive Excel workbooks.

Fix SharePoint Excel Files Not Showing Other Users' Changes
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.
Before you start

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.

Solution 1Recommended

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.

1
Check Access Rights

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'.

2
Confirm Editing Permissions

Review the list of users and groups. Ensure that the collaborators trying to add rows have 'Can edit' permissions rather than 'Can view'.

3
Test Folder Location

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.

Verify SharePoint Document Library Permissions
Test Across Multiple Libraries: If the issue persists, try creating a test Excel file in a completely different SharePoint site to determine if the problem is site-specific.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the official website and install it on your PC, Mac, or mobile device.
  2. 2. Upload to WPS Cloud: Sign in to your free WPS account and upload your existing spreadsheets to WPS Cloud.
  3. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and formulas.Real-time co-editing through WPS Cloud without frustrating sync delays.Free, lightweight, and features a familiar user interface for seamless migration.
microsoft office alternative - wps office

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.