Office Apps Freezing

Fix Microsoft Excel Workbook Freezing During SharePoint Co-Authoring

Tauseeq MagsiTauseeq Magsi Nov 12, 2026 868 views

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.

Fix Microsoft Excel Workbook Freezing During SharePoint Co-Authoring
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.
Before you start

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.

Solution 1Recommended

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.

1
Test with one SharePoint user

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.

2
Compare desktop and web editing

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.

3
Check AutoSave and sync behavior

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.

4
Review SharePoint library controls

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.

Isolate the SharePoint co-authoring or synchronization trigger
Prioritize shared-workflow diagnostics: If the file freezes only with multiple SharePoint users, focus on co-authoring, network connectivity, AutoSave, synchronization, and library settings before rebuilding the workbook.
Free Microsoft Office alternative

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.

Free and lightweight spreadsheet editing for everyday workbook tasksOpen and edit Microsoft Excel .xlsx and .xls workbook formatsFamiliar ribbon-style interface helps users move from Excel quicklyUseful for testing whether workbook calculations and formatting work outside the affected Excel client
microsoft office alternative - wps office

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.