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

Similar Threads

Using Office Forms and dynamically updating the excel backend 0
Linking data in MS Word into Excel 5
Integrating information from Word to Excel (not mail merge) 1
Email notifications without opening application 1
REINSTALLING MS OFFICE PRO PLUS 2019 0
External cell reference between two excel worksheets both in One Drive 0
Significant DELAY to open spreadsheets containing regular links? 6
Opening Excel 2003 file in Excel 2007: Links do not work 5

Top