'%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)
Excel Co-Authoring Version Compatibility & Troubleshooting
Question details
Users need to know which versions of Microsoft Excel support real-time co-authoring and how to resolve synchronization issues in unsupported desktop versions.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to collaborate and co-author Excel files in real-time with other users.
- Observed behavior
- Synchronization issues, such as 'File is locked' or 'Upload failed' error messages, occur when attempting to co-author using perpetual desktop versions like Office Professional Plus 2021 or Office Standard 2019.
Verify the exact version of Microsoft Office you and your collaborators are using, and ensure you have a stable internet connection to support real-time cloud synchronization.
Use a Supported Excel Version for Real-Time Co-Authoring
Switch to Microsoft 365, Excel for the web, or Excel mobile apps to enable real-time collaboration features.
Perpetual desktop versions of Office, such as Office Professional Plus 2021 and Office Standard 2019, do not support real-time co-authoring. To work simultaneously with others, all participants must use a subscription-based or cloud-based version of Excel.
Navigate to office.com and sign in with your Microsoft account credentials.
Click on the Excel icon from the app launcher on the left sidebar to access the web-based version, which fully supports co-authoring.
Open the target workbook from OneDrive or SharePoint. Invite others to edit, and you will see their changes appear in real time.
Resolve 'File is Locked' or 'Upload Failed' Synchronization Errors
Address common errors that happen when a collaborator opens a shared file in an unsupported perpetual desktop version of Office.
Collaborate Seamlessly with WPS Office
If your current perpetual version of Microsoft Office restricts real-time co-authoring, WPS Office provides an excellent, free alternative. It features built-in cloud collaboration tools, robust compatibility with Microsoft Excel files, and a familiar interface so your team can work together without purchasing expensive subscriptions.
- 1. Download WPS Office: Install WPS Office for free from the official website and create a WPS account.
- 2. Upload to WPS Cloud: Open your existing .xlsx workbook in WPS Spreadsheet and click 'Save to Cloud' in the upper toolbar.
- 3. Share and Collaborate: Click 'Share' in the top right corner to generate an edit-enabled link and send it to your team for real-time collaboration.
Frequently Asked Questions
Why does Excel say 'File is locked' when I try to co-author with my team?
This error typically occurs when someone has the workbook open in a version of Excel that does not support co-authoring, such as Office Professional Plus 2021 or Office Standard 2019. To fix this, that user must close the desktop app and open the file in Excel for the web.
Does Office Professional Plus 2021 support real-time collaboration?
No. Perpetual desktop versions like Office Professional Plus 2021 and Office Standard 2019 do not support real-time Excel co-authoring. You must use Microsoft 365, the web app, or the mobile app to co-author.
Can I co-author in Excel if I only have Microsoft 365 Basic?
Yes. While Microsoft 365 Basic does not activate desktop applications, it provides access to Excel for the web and Excel mobile apps, both of which fully support real-time co-authoring.
