Brandon P. answered 05/20/19
Tutor specializing in High School Math and Engineering
You'll need to initially open the main Excel window and the live Excel window. In the main Excel window, create a formula that will reference or look for data in the live Excel spreadsheet. This will reference the exact directory and file to look at when the formula is run. The only trouble is that since it is a live data sheet, it will need to be opened so the main Excel window fetches the latest data.
Also, this live Excel window will need to stay in the same homegroup network and directory and cannot have a changing file name.
Hope this helps!
-TutorB