Update links

  • Thread starter Thread starter wcurtis
  • Start date Start date
W

wcurtis

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.
 
I think this is what you need. Under TOOLS > OPTIONS > "Edit" tab and uncheck
the "Ask to update automatic links".

This should update automatically without asking.
 
Back
Top