Update links

[wcurtis]

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.

 

[Shane Devenshire]

Hi,

You will probably need to write a macro, you can record the Update Links
steps and then attach that code to a

Private Sub Workbook_NewSheet(ByVal Sh As Object)
ActiveWorkbook.UpdateLink Name:= _
"C:\Documents and Settings\Shane Devenshire\My
Documents\PhoneNumbers.xls", _
Type:=xlExcelLinks
End Sub