Troubleshoot Excel for Mac Co-Authoring Locks in SharePoint
Question details
Troubleshoot a SharePoint workbook that appears locked while multiple people try to co-author it.

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

Test Co-Authoring with a New SharePoint Workbook
Use a new workbook to determine whether the problem is specific to the original file.
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.

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.




