Fix Microsoft Excel Workbook Freezing During SharePoint Co-Authoring
Question details
The user needs to identify why an Excel workbook freezes when multiple people edit it through SharePoint, even though the local single-user copy works normally.

- Product
- Microsoft Excel workbook stored in SharePoint
- Device & OS
- not provided
- Scenario
- Several users open or edit a small shared workbook through SharePoint co-authoring or synchronization.
- Observed behavior
- The workbook freezes in the SharePoint collaboration workflow but operates normally when opened locally by one user.
Confirm that all collaborators have permission to edit the same SharePoint file and ask them to close duplicate desktop, browser, or synced-folder copies. Record whether the freeze occurs in Excel desktop, Excel for the web, or both.
Isolate the SharePoint co-authoring or synchronization trigger
Use this first when the workbook works locally but freezes only while it is shared through SharePoint.
A normal local single-user test usually points away from basic file corruption and toward concurrent editing, synchronization, network latency, AutoSave, or SharePoint library configuration.
In the SharePoint document library, have all collaborators close the workbook, then let one user open the file from SharePoint and edit it for several minutes. Add users back one at a time to identify whether concurrent editing triggers the freeze.
Open the same file from the SharePoint library in Excel for the web, then select Open in Desktop App to test Excel desktop. Note which version freezes so you can narrow the issue to the browser, desktop client, or co-authoring service.
In Excel desktop, use the AutoSave switch near the top-left corner to temporarily test the workflow with AutoSave off, if your organization allows it. Also pause or review OneDrive sync from the OneDrive cloud icon and avoid editing a separate synced-folder copy at the same time.
In the SharePoint document library, select Settings > Library settings and review Versioning settings and Require check out. Restrictive checkout or versioning policies can interfere with simultaneous editing workflows.

Reduce workbook features that can stall shared editing
Use this when the freeze follows the workbook across SharePoint sessions or occurs after particular sheets are edited.
Standardize Excel versions and verify the network connection
Use this when only certain users experience the freeze or when the issue happens intermittently.
Use WPS Office for Lightweight Excel-Compatible Workbook Editing
If Microsoft Excel or SharePoint co-authoring remains unstable in your environment, WPS Office provides a free, lightweight office suite with a familiar spreadsheet interface and straightforward migration for compatible workbook files. You can open and edit the workbook locally in WPS Spreadsheets while your organization continues investigating the Microsoft collaboration setup.

Frequently Asked Questions
Why does my Excel workbook work locally but freeze in SharePoint?
A local test uses one user and avoids SharePoint synchronization and co-authoring. If the local copy works, concurrent editing conflicts, AutoSave, OneDrive sync, network latency, or SharePoint library settings are more likely causes.
How can I tell whether Excel desktop or Excel for the web is freezing?
Open the file from the SharePoint document library in Excel for the web, then use Open in Desktop App to test Excel desktop. Compare the results and note whether the issue is limited to one editing client.
Can AutoSave cause an Excel file to freeze in SharePoint?
AutoSave itself is not always the cause, but frequent saves can expose sync, network, or co-authoring conflicts. In Excel desktop, temporarily test the workflow using the AutoSave switch near the top-left corner, subject to your organization's rules.
Which SharePoint settings should I check for an Excel co-authoring problem?
In the document library, open Settings > Library settings and review Versioning settings and Require check out. Checkout requirements and restrictive versioning workflows can prevent or complicate simultaneous editing.
Do Excel add-ins and macros affect SharePoint workbook performance?
Yes. Disable nonessential add-ins through File > Options > Add-ins > Manage COM Add-ins > Go, and test a macro-free copy if possible. Add-ins, VBA, and legacy features can increase delays or behave differently during co-authoring.




