Your calculation mode may be set to manual. Go to
Tools--Options--Calculation and select Automatic.

Then your formulas should update automatically.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"kfell" wrote:

I have a cell containing a VLookup that doesn't contain the correct value
If I click on the cell and then click to edit the function and push enter it
updates to show the correct value.
How can I get a macro to force the cells to update so they show the correct
value?