I use Excel 2010 and I have several Excel-Files with data. I use the VLOOKUP-function with changing dates as lookup value to get the data from these files. The cells have all the time the same function(cell, filepath\file and range, column, false), only the cell with the date is changing.
That works fine, except I add new content to these files and change the date, that the VLOOKUP should find the new value from the file.
If I select the cell and enter the function, the wanted value appears.
Is there any way to update every cell? (maybe with macros?)
And yes the calculation option is automatic not manuel.