Automatic Function Result Update when using A VLOOKUP on another F
Hi all,
I have an excel file A that use a VLOOKUP to retrieve data from another
Excel file B.
The data retrieved in B file is computed with diffrerent funtions that get
data from a database.
When I open file A, the data from B is retrieved BUT the functions into B
are not recomputed so I retrieve out of data data.
Does someone know how to do in order that I get data from file B updated
when I open the file A.
I do not want to ask the users to first go in file B to update data and then
open file A.
Thank you for your help,
--
Quicky
|