Best way to use two computers

Absolutely simplest method is use directory share mapped to a drive letter in Windows.

  1. Create a network share in Windows
  1. Map shared folder to same drive letter using SUBST command on both computers
    subst | Microsoft Learn
    For example: subst X: \\YourComputer\SharedPath

  2. 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.

9 Likes