How do I save 2 linked spreadsheets and update links in formulae
 

you can change the old file name to the new file name using Edit / Replace

"Confused Excel User" wrote:

I have two linked spreadsheets. I want to retain them but do a "save as" and
create a second version. How do I update the formulae to link them in the
new filename?