Sorry, I'm not sure I get it: are you asking (a) how to trigger an update
programmatically, or (b) what may cause Excel to start updating a workbook
when you open it. I suppose it's the latter option? Please clarify.

/MP

"JR" wrote:

Hello,

Upon launching a workbook that has external links we are prompted to hit
update or don't update. Is there code that I use that will prompt update?

Thanks