Formula not coming through
 

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.

Formula not coming through
 

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.

Formula not coming through
 

Maybe calculation is set to manual in ToolsOptionsCalculation?


Gord Dibben MS Excel MVP

On Wed, 5 Sep 2007 14:44:02 -0700, lindsayhyle
wrote:

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.

Formula not coming through
 

That did it, thank you!

"Gord Dibben" wrote:

Maybe calculation is set to manual in ToolsOptionsCalculation?


Gord Dibben MS Excel MVP

On Wed, 5 Sep 2007 14:44:02 -0700, lindsayhyle
wrote:

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.

Formula not coming through
 

That did it, thank you!

"T. Valko" wrote:

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.

Formula not coming through
 

You're welcome!

--
Biff
Microsoft Excel MVP


"lindsayhyle" wrote in message
...
That did it, thank you!

"T. Valko" wrote:

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.