Check and make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomatic

--
Biff
Microsoft Excel MVP


"lindsayhyle" wrote in message
...
Hi,
I did a basic VLOOKUP but I can't get it to pull in the data until I
double
click on the formula in the cell. Like it has to reset or something.
Does
anyone know what is causing this and how to fix it? Thanks.