MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linked cells in other workbooks

Posted by steve on April 02, 2001 9:34 AM

Is there a way to not have the message box pop up asking you if you want to update links, when theres links to other workbooks in the workbook.

Thanks steve

Posted by mseyf on April 02, 2001 10:40 AM


from the menu bar try Tools>Options>Edit>Ask to update automatic links.

if open file via a macro, UpdateLinks:=0,1,2,or 3, depending on what you want done.



Posted by Dave Hawley on April 02, 2001 10:49 AM

Hi Steve

Unfortunately there is no diect way to achieve this. As far as I'm aware you can only do this if you open the Workbook via code. One way to achieve this is to create a Workbook (with no data) and use the Workbook_Open event to open your Workbook.

Private Sub Workbook_Open()
Workbooks.Open "C:\MyDocuments \MyBook.xls", UpdateLinks:=3
End Sub


OzGrid Business Applications