Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In several posts I've seen the following to allow automatic updating of links
on workbook open without the excel warning being displayed. Application.Workbooks.Open Filename:="D:\TEMP\sample.xls", UpdateLinks:=True I've entered the above code in my workbook open event. However, when I open the file, Excel still prompts me with the choise to update or not. After this, the macro results in an error because it want to open my workbook a second time... Any suggestions to what I'm doing wrong here? Using excel 2000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Security Warning Message Bar to update External Links in Excel 200 | Excel Worksheet Functions | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Suppressing Update Links Warning | Excel Programming | |||
Suppress Update Links dialog AND don't update links | Excel Programming | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming |