Excel file locked for editing cant unlock how to#
This can happen for a number of reasons but most important is to know how to resolve it without losing unsaved changes: You may occasionally get a message ‘Refresh recommended’ or ‘Upload failed’. It’s easy to prevent this issue simply communicate with co-authoring participants to ensure everyone accesses the document from the same application. In such a scenario the co-authoring session will most likely crash the document at some point. One user may open a document from SharePoint, another user may access the same document from Microsoft Teams and a third user may open it from One Drive Explorer. There are several scenarios where people can access the same file stored on a cloud. Opening document from different applications To find objects go to Home > Select > Selection Panel. These objects can be invisible and copied and pasted from other documents or web pages. Make sure you turn off the ‘Track Changes’ feature and don’t enable it during a co-authoring session.Ĭo-authoring can also be interrupted if an unsupported object is inserted into a document or spreadsheet, such as an ole object, SmartArt graphic, chart or ink object. Co-authoring doesn’t provide the ability to track changes. One unsupported feature is change tracking. This can stop the co-authoring process temporarily. Using features that are not co-authoring friendlyĬo-authoring can be interrupted if someone uses a feature that is not fully supported in co-authoring. The co-authoring experience may be slightly different for files in different formats but overall you will be able to collaborate if using one of the formats mentioned above. Make sure your file is saved in the right format: There are only certain types of documents that support co-authoring. If you are still getting the ‘locked’ error, see Excel file is locked out for editing. Co-authoring in Excel requires the latest version of Excel installed, and you will need to sign-in to Office with an Office 365 subscription account. The Excel mobile app and the latest version of Excel for Office 365 also support co-authoring. If just one person does this, then everyone else will get the ‘locked’ error - even if everyone else is using a version that does support co-authoring.Ĭo-authoring is supported for Word and PowerPoint on all devices and versions more recent than Office 2010. Using different versions of an applicationĪnother common reason for failed co-authoring is if someone has opened a document with a version that doesn’t support co-authoring. For Office 365 subscribers the AutoSave feature is located in the upper-left corner in Excel, Word and PowerPoint. AutoSave can be enabled when a file is stored in OneDrive, OneDrive for Business, or SharePoint Online. AutoSave is offĪutoSave automatically saves your changes to the cloud as you are working and lets other people see your changes instantly so make sure it’s switched on.
In this article I’ll share a few common reasons why co-authoring may not work and how you can resolve it.
Most of the time it works smoothly but from time to time you may experience some issues.
Co-authoring is a feature that allows multiple people to work together in one document simultaneously without interruption.
0 kommentar(er)
