There are two ways to open a file in a connected drive for viewing and editing: from the local directory or from the data source.
Open a file from the local directory
macOS®–Force-click the file to open it.
Open a file from the data source (Windows® Only)

The file automatically opens on your local machine from the associated connected drive.