If i have two excel files linked . Say excel file 1 and excel file 2.

If excel file 2 updates its results according to excel file 1 , then can I combine the two files so that sheet 1 updates according to values in sheet 2?


Many thanks for any help

MD