Hi everyone! I am in need of your expertise.
We use one shared excel file between 13 people with multiple users logged in throughout the day. Usually this works, but every once in a while the file gets "locked by user for editing" and then we have to hunt down who has the file open, have them save and then close the file in order for someone else to log in.
I was told about using co-authoring instead of the share feature, however all o f the instructions I have found online mention that it needs to be uploaded to either SharePoint or One Drive and that is not an option for us at the moment. We use a shared network folder to store our documents. Is there a way to co-author from the shared network instead?
If not, the other idea I had was to create a two-way master workbook and multi-user work books where any edits made in the user workbook would reflect in the master workbook and vice versa. I'm just not sure how to go about doin this either.
Thank you for your help!
We use one shared excel file between 13 people with multiple users logged in throughout the day. Usually this works, but every once in a while the file gets "locked by user for editing" and then we have to hunt down who has the file open, have them save and then close the file in order for someone else to log in.
I was told about using co-authoring instead of the share feature, however all o f the instructions I have found online mention that it needs to be uploaded to either SharePoint or One Drive and that is not an option for us at the moment. We use a shared network folder to store our documents. Is there a way to co-author from the shared network instead?
If not, the other idea I had was to create a two-way master workbook and multi-user work books where any edits made in the user workbook would reflect in the master workbook and vice versa. I'm just not sure how to go about doin this either.
Thank you for your help!
