How could I fetch live updating Excel data from other computers? I need to fetch that live data to another worksheet on another compter for data analysis under a homegroup network.

Answer 1

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