View Single Post
  #1   Report Post  
Andy
 
Posts: n/a
Default Updating links to new workbook with same format

I have a spreadsheet that is linked to 3 other spreadsheets. We keep a
history of our data for each month, so the file will get renamed every month.
However the file that is linked to the other 3 will still be pointing to
last month's spreadsheets. Is there an easy way to change the links to a new
spreadsheet?