Automatically Update Excel Links
 

I have an Excel spreadsheet that resides in SharePoint. Every time the
spreadsheet is opened a message appears asking is links (within the
spreadsheet) should be updated.

Is there any way; using formulas, VB Code or some other magic :-) to have
the spreadsheet automatically update and to have it update every hour (or
other time period)?

Any help would be greatly appreciated!

Thanks in Advance

--
Rodman Veney