Automatically Update External Links

reefland

New Member
Joined
Jun 18, 2002
Messages
14
Good day All,

I have a lot of external links, all of which can be simply updated by:
Edit >> Links >> Select All >> Update >> Close
However I would like to automate this process. Can't really record a simple macro because it hardcodes the links and they are changed each day. Is there any way to perform the above every 5 minutes (or so) automatically?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Do you mean --

Tools | Options | Calculation tab

check Update remote references
check Save external link values
 

reefland

New Member
Joined
Jun 18, 2002
Messages
14
Those are already checked.

Right now if someone else with network access updates a workbook and saves it, from a workbook that I am pulling informtion from, the data in my workbook will not update until I go to Edit >> Links >> Select All >> Update Values. What I want to do automatically update these links so as soon as new information is added to a linked workbook and it is saved, it is displayed in the destination workbook.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Sorry, no clue as to how to do that.

Maybe somebody else can give some ideas.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,491
Members
412,669
Latest member
nickyon1
Top