VLOOKUP Problem, Please Help!

[Susan]

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!

 

[T. Valko]

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic>OK

 

[Gaurav]

Check

Tools | Options | Calculation tab | Automatic