Forum Discussion
VLOOKUP data refresh
You write that the client is updating records in File 1, which I'm taking to mean, making changes to existing records, as opposed to adding new records. If that's a correct interpretation, then they (or somebody else) should get a message when opening File 2, that looks like this:
They just need to answer "Update" and the VLOOKUP formulas in File 2 will get the updated information from File 1.
If in fact they're adding altogether new address records then you might need to change the range of the cells in File 2 to make sure that range is large enough to accommodate the new data.
P.S. I am speaking from experience with Excel. Never used SharePoint though, so if it introduces some different processes, what I have written might not be complete.