Forum Discussion
Turn Off Read Only
Hey guys, Hoping someone can help out with this, there are 5 of us here in the office all using our boss' Microsoft office licence. Mainly using excel and unable to open Excel files at the same t...
Hi there, thanks very much for that! I should have mentioned that files are on a local shared network and it happens with all of them. We can use the Save-As for a workaround but this happens when 2 files are opened at the same time. I will try and get a screenshot if it helps Thanks!
Hi shaneoc14
You can only co-author files if they are saved to OneDrive or SharePoint.
There is an old option to "ShareWorkbooks" but it was always buggy and not really recommended.
Afraid here is the bug not in functionality, but in scenario of use. Actually same license on 5 different PC:s means same user simultaneously works with same shared file on different clients. Excel sharing is not designed for such scenario. I guess it keeps temporary files under users ID:s and syncs them on each Save. If all ID:s are the same Excel has no idea how to sync and ask to close extra copy first.
Above is just my guess, didn't test that.
And yes, co-authoring has no such limitation, as well as many others.
