Thread: Update links
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wcurtis wcurtis is offline
external usenet poster
 
Posts: 24
Default Update links

Is there a way to update all of the links in a sheet automatically? I have a
sheet I copy into a workbook and need to update the sheet links with several
other sheets in the book. The workbook will not have the same number of
sheets everytime so a macro won't work.