Forum Discussion
excel on network setup
Hi sailor-123
If your file is stored on a file server and not in a SharePoint document library, unfortunately you will not have the ability to do (real-time) co-authoring of documents.
You'll encounter the traditional locked file by a user and they must exit for others to use the file.
Cheers
Damien
Hi Damien, thank you for your reply. I am actually not sure how the network setup works. it seems to me that the users are working through a kind of remote desktop on the server itself where the relevant programs are installed. The main application is a database. Would that be possible?
- SergeiBaklanFeb 10, 2020Diamond Contributor
You may allow simultaneous editing using legacy file share, but not all functionality works for such variant About the shared workbook feature
Didn't catch the question about licensing. That's per-user licensing of Excel (or entire Office), doesn't matter with which files they are working.
- Damien_RosarioFeb 10, 2020Silver Contributor
Hi sailor-123
Same rule applies unfortuantely. If it isn't stored on SharePoint, then accessing the file via Excel will only allow one user at a time.
If, however, your third party Database application manages the user interactions using the data in Excel, then it may be possible but you'd have to check with your internal IT team on your database applications features.
Hopefully the above gives you something to ask your IT guys and I would also encourage you to test out a copy of the doc on the remote server to verify what we've discussed. I suspect it won't allow co-authoring based on what I understand of your scenario.
Good luck and please do let us know how this turns out!
Best wishes
Damien