File Sharing Problems

Troubleshoot Excel for Mac Co-Authoring Locks in SharePoint

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 869 views

Question details

Troubleshoot a SharePoint workbook that appears locked while multiple people try to co-author it.

Troubleshoot Excel for Mac Co-Authoring Locks in SharePoint
Product
Microsoft Excel for Mac and SharePoint
Device & OS
macOS and Windows
Scenario
Several collaborators need to edit the same SharePoint workbook using Excel on Mac and Windows.
Observed behavior
The workbook appears locked by another user, preventing or interrupting co-authoring.
Before you start

Locate the workbook in SharePoint and ask collaborators which accounts and Excel versions they are using. Make sure everyone has permission to edit the same file.

Solution 1Recommended

Check Excel Versions, Accounts, and Active Editing Sessions

Use these checks to identify an outdated app, account mismatch, or active session that may be causing the lock.

1
Check Excel for Mac

In Excel for Mac, select Excel > About Excel and check the version. Use version 16.24 or later; select Help > Check for Updates to install available updates.

2
Check Windows Excel

In Excel for Windows, select File > Account to review the signed-in account and update information. If Update Options is available, select Update Options > Update Now.

3
Verify accounts and access

Ask each collaborator to check the account shown in Excel and confirm that the same account has edit access to the SharePoint workbook. Open the shared file directly from its SharePoint location.

4
Review active sessions

Ask the user named in the lock message and other collaborators to save their edits and close the workbook in Excel and any browser tabs. Wait briefly, then reopen the file from SharePoint.

5
Try Excel for the web

In the SharePoint document library, select the workbook and choose Open > Open in browser. Check whether you can edit it there, then compare the result with opening it in the Excel desktop app.

Check Excel Versions, Accounts, and Active Editing Sessions
Allow time for a lock to clear: A lock can remain temporarily after a session closes. Coordinate with collaborators before closing sessions so they can save their work.
Free Microsoft Office alternative

Edit Excel Workbooks with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing files into WPS; it does not resolve Microsoft Excel or SharePoint co-authoring locks.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheets in a familiar interfaceMove existing Office documents into a lightweight applicationUse a free alternative for everyday spreadsheet editing
microsoft office alternative - wps office

Frequently Asked Questions

How do I check my Excel version on a Mac?

Open Excel and select Excel > About Excel. For this troubleshooting check, use version 16.24 or later and install available updates through Help > Check for Updates.

Why does the workbook still say another user has it locked?

Another editing session may still be open, or a lock may take time to clear after it closes. Ask the named user to save and close the workbook in Excel and browser tabs, then wait briefly before reopening it.

How can I tell whether the problem is with one workbook?

Create a blank workbook, save or upload it to the same SharePoint library, and share it with the same collaborators. If they can co-author the new file but not the original, investigate the original workbook and its active sessions.

Can I test the workbook without the Excel desktop app?

Yes. In the SharePoint document library, select the workbook and choose Open > Open in browser. Try editing it in Excel for the web and compare the result with the desktop app.