Forum Discussion
I can't do Co-authorizing on shared OneDrive file that is on my PC
I shared a folder to a collogue of which she has saved so it is online and also a hardcopy on the computer. When she opens an excel file from the computer, it does not show the Co-authorizing ability. We can track each others activity. I can only see Co-authorizing when she uses the online version. Additionally anytime she makes a change to the PC file, if I have the same file open, her OneDrive immediately has an error and forces her to save as a copy. Please note, if she is using the online file, I can collaborate from the same file from my PC. The issue seems to only occur when we are both using our PC version of the same file.
Can anyone help with this. I would like for us to both collaborate from the PC file.
Co-authoring in Excel desktop only works when the file is truly cloud-based.
Requirements for Excel Desktop Co-authoring to Work
- File must be stored in OneDrive or SharePoint Online
- The file must be opened from the cloud, not just the local sync folder
- AutoSave must be turned on
- Both users need to be using Excel 365 or 2019+
- The file must not be password protected, macro-enabled (.xlsm), or opened in compatibility mode
Or…
Use Office Online (Web)
This always supports co-authoring:
- If both users open from https://onedrive.live.com, collaboration is seamless.
- Useful for quick edits if desktop syncing is causing trouble.
I hope I could help
1 Reply
- NikolinoDEGold Contributor
Co-authoring in Excel desktop only works when the file is truly cloud-based.
Requirements for Excel Desktop Co-authoring to Work
- File must be stored in OneDrive or SharePoint Online
- The file must be opened from the cloud, not just the local sync folder
- AutoSave must be turned on
- Both users need to be using Excel 365 or 2019+
- The file must not be password protected, macro-enabled (.xlsm), or opened in compatibility mode
Or…
Use Office Online (Web)
This always supports co-authoring:
- If both users open from https://onedrive.live.com, collaboration is seamless.
- Useful for quick edits if desktop syncing is causing trouble.
I hope I could help