Links cannot be updated

[Guest]

I'm opening some spreadsheets using vba that have links in them. When the
spreadshet opens, the message 'This workbook contains one or more links which
cannot be updated'. I'm presented with a continue and exit button. I click
the continue button and my program runs without issue. Is there a way for me
to tell excel that I want to continue in my vba program so I don't have to
manually click the button every time a spreadsheet is opened?
Thanks in advance.

 

[Jim Rech]

Are you setting the Openlinks parameter of the Workbooks.Open method to
False?

Also, if you cannot find the reason for the links and you want to, get The
FindLink utility here:

http://www.bmsltd.ie/MVP/Default.htm