periodically updating links to data in other workbooks

djjester

New Member
Joined
Mar 18, 2006
Messages
21
Hey guys,

I would have thought this would be a common issue but after having a bit of a search I haven't been able to find a solution.

I have a workbook that reads in numerous values from a number of other workbooks (which are continually being written to and changing). When I first open this workbook it prompts me to update the information from the other workbooks.

At this point I have the most up to date values from the other workbooks. However periodically I want to refresh all of these values from other workbooks (all in one go). I understand this may take a long time as many files are being accessed and values read, however that is fine.

Currently if I use "F9" to update, it will recalculate values but will not obtain the most recent values from other workbooks.

I have written a macro that basically hits "F2" and then "Enter" over each cell, although this takes a very long time (even for just 24 reads over 12 sheets).

Is there a function or macro that will just do sheet at once updating (like the one that you are prompted with when you first open a workbook)?

Any help would be great.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

cmhoz

Active Member
Joined
Aug 20, 2006
Messages
268
Could you use a macro that does:

Edit --> Links --> select all & update now

It might run faster?
 

djjester

New Member
Joined
Mar 18, 2006
Messages
21
Hey cmhoz,

Thanks for the reply.

actually i just checked and even the initial update links question doesn't read in the latest values.

maybe it is because the other workbooks are open at the time.

the only way i can do it so far is with the F2 and enter solution.
 

djjester

New Member
Joined
Mar 18, 2006
Messages
21
Anyone else got any idea's on how to update all data from linked worksheets in one go?
 

Forum statistics

Threads
1,137,366
Messages
5,681,072
Members
419,950
Latest member
BeckiJae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top