Hi There:
I have Vlookup formulas in one master spreadsheet that look for values in other spreadsheets contained in other files.
However, the master file I work from does not calculate or update the cells automatically when someone makes a change to the file that Vlookup command is trying to find.
Instead I have to open up each file individually in order to get the new numbers reflected in the master file.
How can I get the changes reflected in the master file without individually opening each and every supporting file that feeds it with numbers?
I have Vlookup formulas in one master spreadsheet that look for values in other spreadsheets contained in other files.
However, the master file I work from does not calculate or update the cells automatically when someone makes a change to the file that Vlookup command is trying to find.
Instead I have to open up each file individually in order to get the new numbers reflected in the master file.
How can I get the changes reflected in the master file without individually opening each and every supporting file that feeds it with numbers?