That does a full recalc. If it doesn't work for you, I am not aware of a
combination that does more. I suspose it is possible that you have some
unhandled error in a UDF that might be causing calculation to quit.

Another thing you could try is to select one cell or all cells and doing
Edit=Replace
What: =
With: =

so you replace all equal signs with equal signs. This should be equivalent
to doing F2 in every cell (of course you could select a smaller range and do
it as well).

--
Regards,
Tom Ogilvy

"Brian K. Sheperd" wrote in message
...
I just tried the Ctrl+Alt+F9, but it did not do anything. I am using
Office
2000 -- is that combination good for all office versions? Or do I need to
enable something in the options area?

Thanks,
Brian


"Tom Ogilvy" wrote in message
...
Ctrl+Alt+F9

--
Regards,
Tom Ogilvy

"Brian K. Sheperd" wrote in message
...
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