How to create a "virtual" local area network over the Internet?

Question

Computer networks

There is a need to work with shared excel files for employees from different cities. The situation is complicated by the fact that Excel files are interconnected and data is exchanged between them. Before that, they successfully worked within the same office on a local network, but now they have expanded ... How can this be organized without strong problems? in extreme cases, can there be any service?

Answer 1

Wouldn't it be better to switch to Google Sheets, they have group work more decently organized than the file version of Excel, and you won't have to build any VPNs?
Well, the simplest is Hamachi, or VPN on branch gateways.

Answer 2

VPN. You can build in different ways.

Answer 3

If you have several offices / branches, then you need to connect them with a VPN tunnel over the Internet, this is configured on the office routers. select the tunnel based on the capabilities of your routers.

Answer 4

As they wrote above, a viable option is organizing vpn between offices.