| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I add cells the sum is coming up $0.00 | Excel Discussion (Misc queries) | |||
| need help coming up with a formula. | New Users to Excel | |||
| New user needing help with coming up with a formula | New Users to Excel | |||
| I'm always coming up against this! | Excel Discussion (Misc queries) | |||
| Coming up with #N/A | Excel Worksheet Functions | |||
Linear Mode
