View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
Quicky Quicky is offline
external usenet poster
 
Posts: 1
Default 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