Formula not coming through

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Check and make sure calculation is set to automatic.

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


Gord Dibben MS Excel MVP
 
Back
Top