View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default 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?