Hi Andy,
It sounds like you're opening the workbook via code. If that's the case,
you can use the UpdateLinks argument to the Open method. So if you want to
update links automatically, you can do this:
Workbooks.Open Filename:="c:\test.xls", UpdateLinks:=3
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
I have a spreadsheet that needs a user input.
It says
"This workbook contains links to other data sources
If you update this, Excel attempts to retrieve the latest data.
If you dont update, excel uses the existing data"
There are 3 buttons, Update, Dont Update and Cancel.
I want it to just press the Update option as its highlighted and carry
on but application.Displayalerts = False does not get it past it.
Any ideas?
---
Message posted from http://www.ExcelForum.com/