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.

Update links
 

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.
--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"wcurtis" wrote:

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.