I have a worksheet with 170 columns and another with a vlookup formula. when
i first created the vlookup the formula worked fine, but when i change one of
the numbers in the 170 columns, the number does not change on the other
spreadsheet.

I have changed the format and they are formatted the same, i have tried
general and number as well.

Anyone have any ideas why the VLOOKUP is not updated? Please help!

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"Susan" wrote in message
...
I have a worksheet with 170 columns and another with a vlookup formula.
when
i first created the vlookup the formula worked fine, but when i change one
of
the numbers in the 170 columns, the number does not change on the other
spreadsheet.

I have changed the format and they are formatted the same, i have tried
general and number as well.

Anyone have any ideas why the VLOOKUP is not updated? Please help!

Check

Tools | Options | Calculation tab | Automatic


"Susan" wrote in message
...
I have a worksheet with 170 columns and another with a vlookup formula.
when
i first created the vlookup the formula worked fine, but when i change one
of
the numbers in the 170 columns, the number does not change on the other
spreadsheet.

I have changed the format and they are formatted the same, i have tried
general and number as well.

Anyone have any ideas why the VLOOKUP is not updated? Please help!