Update links

W

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top