Absolutely simplest method is use directory share mapped to a drive letter in Windows.
- Create a network share in Windows
-
Map shared folder to same drive letter using SUBST command on both computers
subst | Microsoft Learn
For example:subst X: \\YourComputer\SharedPath
-
From now on, on both computers you can refer to shared data using exactly same path say
X:\MyData
You can share the formulas, databases and other data folders that way.
This is built-in functionality in every Windows since 95 and does not require any third party software nor any kind of cloud.