Automatically Update Excel Links

R

Rodman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top