There's a link that you (and excel) aren't finding.

I'd get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

ps. When excel opens the file, it reacts to the links before it gets to your
code.



Tasha wrote:

I keep getting an Update Link prompt every time I open a file. The prompt
asks to Continue or Edit Links. If I go into Edit links, they are showing
status OK. I don't want this prompt. I have done EditLinksStartup Promp
and checked 'Don't display the alert and update links', saved and closed the
workbook. Upon opening, the link prompt is still coming up. I have told it
not to ask to update, and even tried putting
Application.AskToUpdateLinks=False in the open workbook code, and it is STILL
coming up. Can someone please tell me how to get this prompt to turn off?

--

Dave Peterson