Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Linked cells in other workbooksPosted 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.
Re: Linked cells in other workbooks - Tools>Options>EditPosted 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.
Re: Linked cells in other workbooksPosted by Dave Hawley on April 02, 2001 10:49 AM
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
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.