'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Co-Authoring Errors in SharePoint
Question details
Users encounter co-authoring errors such as upload failures, merge conflicts, or sheet view restrictions when multiple people simultaneously edit an Excel file hosted on SharePoint.
- Product
- Microsoft Excel / SharePoint
- Device & OS
- not provided
- Scenario
- Multiple users editing the same Excel workbook simultaneously in SharePoint.
- Observed behavior
- Errors appear stating 'Your file cannot be uploaded because your changes cannot be merged' or 'We can't do that in this sheet view' during simultaneous table edits or when using mixed clients.
Verify that your Excel workbook is saved in SharePoint Online and uses the modern .xlsx file format, as older formats like .xls do not support co-authoring.
Standardize on Excel for the Web
Prevent merge conflicts by ensuring all collaborators use the supported web version instead of unsupported or mixed desktop clients.
Excel co-authoring often fails when different clients attempt to merge simultaneous changes. This is especially true when some users are on Excel for the web while others use unsupported desktop clients like Excel included with Office LTSC.
Instruct all users currently accessing the file to save their changes and completely close the workbook in their desktop versions of Excel.
Navigate to the SharePoint document library hosting the file and click the file name to open it directly in Excel for the Web.
Check the top right corner of the web interface to ensure other users' avatars appear, indicating that real-time co-authoring is active and supported.
Switch to the Standard Worksheet View
Resolve the 'We can't do that in this sheet view' error by reverting to the default shared view.
Raise a Support Request via Microsoft 365 Admin Center
If errors persist despite using supported clients and correct formats, an administrator may need to investigate backend sync issues.
Collaborate Seamlessly with WPS Office
If Microsoft Office co-authoring errors continue to disrupt your team's workflow, try WPS Office. It provides a lightweight, highly compatible, and free alternative with powerful built-in collaboration features.
- 1. Download WPS Office: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install and Sign In: Install the software and log in using your email, Google, or other third-party accounts to activate cloud features.
- 3. Upload and Collaborate: Upload your existing .xlsx files to WPS Cloud to begin editing and collaborating in real-time with your team members.
Frequently Asked Questions
Why do I get a 'changes cannot be merged' error in Excel?
This error typically occurs when multiple people edit the same table rows or cell values simultaneously, or when users mix Excel for the Web with unsupported desktop clients (like Office LTSC). Having everyone use Excel for the Web usually resolves the conflict.
Does the older .xls format support co-authoring?
No, co-authoring is only supported on modern file formats such as .xlsx, .xlsm, or .xlsb. You must convert older .xls files to the modern .xlsx format to enable multiple users to edit the file at the same time.
What is an Excel Sheet View and how does it affect editing?
Sheet Views allow individual users to create customized filters and sorts without affecting what other collaborators see. However, structural changes like inserting or deleting rows are restricted in this mode. You must switch back to the Default view under the View tab to perform these actions.
