There is an option under Tools|Options|Calculate to 'update remote references'

You can add the code to workbook_Open method...

Typically Excel prompts the user to update the links...

--
Always provide your feedback...


"Brent E" wrote:

Good day,

I need to set a macro or VBA module to be stored w/ the worksheet that will
automically update links upon openning of the file. Can I do this through
code at the file level or this an global office setting?

Thanks,