Excel Performance Problems

Fix Excel Workbook Slow or Crashing with Multiple Users in SharePoint

Algirdas JasaitisAlgirdas Jasaitis Nov 4, 2026 871 views

Question details

Users experience severe lag or application crashes when simultaneously editing a macro-enabled Excel workbook stored in SharePoint Online via Excel Desktop.

How to Fix Excel Workbook Slow or Crashing During Multi-User Editing in SharePoint
Product
Microsoft Excel Desktop, SharePoint Online
Device & OS
not provided
Scenario
Multiple users attempting to co-author or simultaneously edit a macro-enabled workbook.
Observed behavior
The Excel application slows down significantly or completely crashes when multiple users are active, whereas it performs normally for a single user.
Before you start

Verify that your internet connection is stable, and ensure that all users have saved and closed the workbook before you begin troubleshooting add-ins or repairing the software.

Solution 1Recommended

Disable COM and Application Add-ins

PDF-related and other third-party add-ins often conflict with Excel's co-authoring features in SharePoint. Disabling them can resolve crashing issues.

Third-party add-ins like Adobe PDF and PDF-XChange can interfere with the background syncing processes required for real-time collaboration. Disabling them helps isolate compatibility issues.

1
Open Excel Options

Launch Excel Desktop, click on the 'File' menu in the top left corner, and select 'Options' at the bottom.

2
Access Add-ins

In the Excel Options window, click on 'Add-ins' in the left-hand navigation pane.

3
Manage COM Add-ins

At the bottom of the window, ensure the 'Manage' dropdown is set to 'COM Add-ins', and click the 'Go...' button.

4
Disable Third-Party Add-ins

Uncheck the boxes next to any third-party add-ins (such as Adobe PDF or PDF-XChange) and click 'OK'.

5
Restart and Test

Restart the Excel application and ask another user to open the SharePoint workbook to test if the crashing issue is resolved.

Disable COM and Application Add-ins
Identify the Culprit: If Excel runs smoothly after this, re-enable the add-ins one by one to identify the specific plugin causing the crash.
Free Microsoft Office alternative

Seamlessly Collaborate with WPS Office

If Microsoft Excel continues to crash or lag during multi-user editing, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with robust cloud collaboration features that prevent desktop application crashes.

  1. 1. Open your Workbook in WPS Office: Launch WPS Spreadsheet and open your existing Excel workbook directly without altering its format.
  2. 2. Save to WPS Cloud: Click the 'Cloud' icon to upload the file to WPS Cloud for secure, real-time syncing.
  3. 3. Share and Co-Author: Click the 'Share' button in the top right corner to invite team members via a link, allowing multiple users to edit simultaneously without lag.
Highly compatible with Microsoft Excel formats (.xlsx, .xlsm, .csv).Real-time co-authoring and document sharing via WPS Cloud without desktop slowdowns.Free, lightweight, and uses minimal system resources.Familiar user interface requires no learning curve to migrate.
microsoft office alternative - wps office

Frequently Asked Questions

Can macro-enabled workbooks (.xlsm) be co-authored in Excel Desktop?

Yes, Excel Desktop supports co-authoring for macro-enabled workbooks stored in SharePoint or OneDrive. However, macros must not be triggered constantly or interfere with the application's save and sync processes, as this can lead to severe lag and crashes.

Why do PDF add-ins crash Excel during multi-user editing?

Third-party add-ins like Adobe PDF or PDF-XChange inject their own processes into Excel. When multiple users edit a file simultaneously, the frequent syncing required by SharePoint can conflict with these add-in background processes, causing Excel to hang or crash.

Does Excel for the web handle multiple users better than Excel Desktop?

Excel for the web is heavily optimized for real-time co-authoring and handles multiple simultaneous users smoothly. However, it does not support running VBA macros, which is why teams relying on automated macros must use the Excel Desktop application.