Update cells whose source is in a closed workbook

Originally Posted by Richard Buttrey

Hi,

Why do you need to do anything at all other than accept and say yes to the links being updated whenever you open the Estimates book?

If you allow the links to update any changes that have been made in the 'file' source workbook will be reflected in Estimates.

Regards

Hi Richard,

My concern was that in the estimates workbook I have a cell where I ask the user to enter a date. From this date, the VLookup searches for the approriate data in the closed workbook, "file".

So changing the date in this cell didn't update the links in estimates since file was closed.

However, I just highlighted all the cells with a VLookup, clicked Edit --> Links --> selected "file" --> Update links

Does this now mean that whenever I change the date in the cell that the VLookups will automatically grab the right data, since they're linked to the closed workbook?
Essentially, I wouldn't need a macro at all if this were the case...