Update links

[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.

 

[JBeaucaire]

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.