I have two excel files that I am linking, where one file always keeps the same file name (File 1.xls) and another file that is opened as read only and then saved as a different name (File2.xls).
So File1.xls is from a supplier and is consistently updated and calculates certain results...