Fix SharePoint Excel Co-Authoring Fails for XLSM Workbooks
Question details
Multiple users experience upload conflicts and synchronization failures when attempting to co-author an XLSM workbook in Excel desktop via SharePoint.

- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- A group of users is trying to collaborate simultaneously on a macro-enabled workbook (XLSM) using the Excel desktop application connected to SharePoint.
- Observed behavior
- Users encounter slow uploads, synchronization errors, and upload conflicts where one person's save overwrites another, leading to a high risk of data loss and corruption.
Ensure all users have saved a copy of their current progress locally as a backup to prevent any data loss before attempting to clear the Office cache or restart the sync process.
Clear Office Cache and Restart the Application
Clearing the cached Office files and signing back in can resolve temporary sync glitches and stuck uploads causing conflicts.
When Excel's document cache becomes corrupted or a file upload hangs, it prevents other co-authors from syncing their changes successfully. Resetting this cache forces Excel to establish a fresh connection with SharePoint.
Open the Microsoft Office Upload Center (or Office Document Cache settings in newer versions), go to Settings, and click 'Delete cached files' to remove pending uploads.
Open Excel, click on 'File', select 'Account', and click 'Sign Out' for all connected Microsoft accounts.
Close all Office applications completely, restart your computer, open Excel, sign back into your account, and attempt to open the XLSM workbook from SharePoint again.

Use SharePoint Check-Out for Exclusive Editing
Checking out the file locks it for a single user, preventing the simultaneous editing conflicts associated with XLSM files.
Experience Seamless File Sharing and Collaboration with WPS Office
If Microsoft Office synchronization issues are interrupting your team's workflow, try WPS Office. It provides a lightweight, highly compatible alternative with built-in cloud collaboration features to keep your team on the same page without the frustration of constant sync errors.
- 1. Download WPS Office: Install WPS Office for free on your desktop or mobile device.
- 2. Open Your Workbooks: Open your existing Excel files directly in WPS Spreadsheet with full format preservation.
- 3. Collaborate via Cloud: Save your documents to WPS Cloud to easily share links and manage team editing without upload conflicts.

Frequently Asked Questions
Why does co-authoring fail specifically for XLSM workbooks in SharePoint?
Macro-enabled workbooks (XLSM) contain active code and complex structures that complicate simultaneous editing. Many versions of Excel and SharePoint do not fully support real-time co-authoring for these file types, leading to sync conflicts and locked files.
How can I recover data if a co-authoring conflict overwrote my work?
You can recover previous versions by navigating to your SharePoint document library, right-clicking the affected XLSM file, and selecting 'Version History'. This allows you to view and restore a clean version of the workbook from before the conflict occurred.
Does OneDrive have the same XLSM co-authoring issues as SharePoint?
Yes, because OneDrive and SharePoint utilize the same underlying Microsoft sync engine. Attempting to simultaneously co-author macro-enabled workbooks on Excel desktop applications via OneDrive can result in identical upload conflicts and synchronization failures.




