View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TJAC TJAC is offline
external usenet poster
 
Posts: 26
Default Updating Links to a new spreadsheet

We are trying to update a spreadsheets links, which there are many, to a new
Source Workbook. The old Source workbook was called 2007, now the new Source
workbook is called 2008. We have attempted a find and replace, but each time
it asks us to go out and find the new workbook again to update the link.
This spreadsheet has so many links it would take a very long time to point to
the same workbook each time. Is there a faster/easier/better way to do this?

Thanks!
Trisha