Update links without being asked

Mar 11th, 2002, 08:47 AM

When a workbook has links in it and it is opened, Excel automatically asks you "Do you want to update links...." and if you press "no" the links are not updated. Is there a way to have the links updated automatically WITHOUT having Excel ask you?

I tried using the statement
Application.AskToUpdateLinks = False
in the Workbook_Open object, but the message still pops up. Anyone have any ideas?

Mar 11th, 2002, 08:58 AM

http://www.mrexcel.com/board/viewtop...1706&forum=2&4

Mar 11th, 2002, 09:13 AM

Thanks that helps!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 08:47 AM	#1
Guest Posts: n/a	When a workbook has links in it and it is opened, Excel automatically asks you "Do you want to update links...." and if you press "no" the links are not updated. Is there a way to have the links updated automatically WITHOUT having Excel ask you? I tried using the statement Application.AskToUpdateLinks = False in the Workbook_Open object, but the message still pops up. Anyone have any ideas?

Mar 11th, 2002, 08:58 AM	#2
Guest Posts: n/a	http://www.mrexcel.com/board/viewtop...1706&forum=2&4

Mar 11th, 2002, 09:13 AM	#3
Guest Posts: n/a	Thanks that helps!!