Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

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

Re: Linked cells in other workbooks - Tools>Options>Edit

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

Steve:

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.

HTH

Mark

Re: Linked cells in other workbooks

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

Dave

OzGrid Business Applications

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.