Unwanted Link Msgs & Errors

[Sid]

SInce I started Excel 2003, every time I open a workbook I
get either a link update message immediately or I get a
blinking title bar, which I now know means Excel has a link
update message to give me. The message is something like:
"This workbook contains links to other data sources.
If you want to update . . ., etc"

I'm running the same 30 or so workbooks (all linked
together) that I've been using for about a year, and I
NEVER got one of those messages from my previous version of
Excel. When I go to the Links window, I see they have a
nice box to check if I want the links to be updated
automatically. I checked it, but I still get the messages.
They have an additional option to check if I want the
updates and I don't want the messages. I checked it. I
still get the messages. It's really annoying when I have a
series of workbooks that execute macros, then open the next
workbook, and close the original in a daisy chain fashion.
Anyone know how to coax Excel to update the links and not
bother me with it unless there is an error?

 

[Frank Kabel]

Hi
in your macro you may use the lines
application.displayalerts = false
'open the workbook
'process and close the workbook'
application.displayalerts = True

you may also take a look at the UpdateLinks property in the VBA help