Formula not coming through

L

lindsayhyle

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.
 
T

T. Valko

Check and make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic
 
G

Gord Dibben

Maybe calculation is set to manual in Tools>Options>Calculation?


Gord Dibben MS Excel MVP
 
Top