I'm not sure if you are understanding me. Excel INDEED allows you to SHARE a workbook.
If two people are on the same network you CAN share the EXCEL spreadsheet. Two people can be in the sheet at once, and it is updated either upon saving, or by an amount of time you designate in Excel.
Excel ALLOWS you to share.....you simple change the settings to SHARE.
There are limitations....ie, if the two people try changing the same CELL, then it will warn you when saving and ASK YOU which change you want to keep.
What I am talking about in the use of Office 360 and ONEDRIVE....you CANNOT AT ALL....have 2 people working at the same time. When the first person OPENS the file on ONEDRIVE no proble. But when the SECOND person tries to open the file....you get a message saying "File is already in use" and then gives you the option to open it as READ ONLY.
I did some research into 360 and ONEDRIVE and they do not allow SHARING....ie it will NOT work as if it were a NETWORK DRIVE.
Now that leads me to a VPN and my question. If I use a VPN to open the file remotely, will it allow me to share the file. Again....two people working on the network CAN SHARE A SPREADSHEET. The question is.....is attaching remotely through a VPN to a file the same as BEING there on the network.
I dont know enough about the protocols of file sharing to know if VPN access is the same as access on the same network.