Workbooks Changing Reference Locations

[PlumGr8]

So, hope this is my last issue for a while. So i have one main "master" workbook that feeds information in to several other workbooks. Issues seems to be that every day we save the "master" file, then "save as" and name is the date & time, ex. Master 20210101 0600. Issue seems to be that if any of the other workbooks are open, that they will now automatically change their source from the "master" to the "Master 20210101 0600" workbook. Is there a way to edit the link so that they DO NOT change or update? Thanks.

 

[Marc L]

​

The last double quote and parenthesis are missing in your INDIRECT sample …​

​

On my side it works only if the master source workbook is opened.​

If I change the 'link cell' in the Master workbook the value is well updated to the Data workbook in the cell where the INDIRECT formula stands …​

Is the Calculation is set to automatic ?​

 

[PlumGr8]

Sorry, i copied it down wrong, i do have that in the formula but still fails to update.

 

[PlumGr8]

I did post it as another thread as well, didn't meant to clutter up this one