The answer, as you suspected, is "NO".

You would need to link to the file  that is being changed if you wanted to
achieve this.

If the file is set up to allow sharing you can have it open in your instance
of excel at the same time as the owner. Then you can link to it. Your view
of the file updates  periodically when the owner changes it.