periodically updating links to data in other workbooks

[djjester]

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.

 

[cmhoz]

Could you use a macro that does:

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

It might run faster?

 

[djjester]

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]

Anyone else got any idea's on how to update all data from linked worksheets in one go?