Or for 2007

Office button|Excel options - Advanced and scroll down and un-check

Mike

"Neil Holden" wrote:

Morning, i have an excel workbook to automatically open at a specified time,
i have code to run a macro to and close the excel sheet after a certain time.

The trouble i'm having is when the excel opens its asking to update links
YES or no, is they anyway i can automatically update the links instead of
having to press yes?

Thanks,