How can I update links automatically when I drop a worksheet into a workbook?
I have a data sheet that contains links to all the worksheets in my
workbook. I use the data sheet as a template. I select update links when I
copy the worksheet into my workbook but, I have to manually select each item
to update it. Is there a way to update all of my links when it is dropped
into the workbook? I have already checked my calculations to make sure they
are automatic.