Hi,

Tools|Options|Edit

Un-check 'Ask to update links'

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,