I created a VBA/XLA function to extract matching data from an Access
database (similar to a vlookup function); however, if I change the values in
the database, I cannot get the formulas in excel to update. If I hit F2 on
the cell of the part number and hit enter, or if I change the part number,
then the function to fill in the price will update. F9 or re-opening the
file doesn't do anything. I would like to have it update when the file is
opened. Is there anything that I can do to get this to work as I was hoping
for?



Thanks,

Brian