Sounds like you have manual calculation, ToolsOptionsCalculation. Check
the setting.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Code Numpty" wrote in message
...
Excel 2003 - I have a VLOOKUP formula which I have copied down the column.
When I check the formula it has copied down correctly, yet the result
returned is that for the first cell in the column for every single one.

To get the correct result I have to double-click every single cell
containing the formula, which will then show the correct result.

This has only started happening recently. Has Excel corrupted in some way?