Vlookup not copying down

[tryer]

I'm having an unusual problem with Vlookup. I enter the formula in a cell and it produces the correct result. However when I copy down the displayed result is exactly the same as in the original cell. When looking at the formulas I note that the lookup cell has been incremented correctly. for example:the original formula is:

Please Login or Register  to view this content.

dragging this down the next row formula is:

Please Login or Register  to view this content.

and so on. However the result for each cell is the same as in the top one. I have noticed however that if in the formula I manually delete 'A3' and type in 'A3' then it produces the correct result so obviously something is going wrong when draging down the formula even though it appears to be correct

any idea's?

[arthurbr]

Can you post a sample of your sheet?

[martindwilson]

that will happen if calculation is set to manual
look in tools/options/calculation

[tryer]

that will happen if calculation is set to manual
look in tools/options/calculation

Spot on - Thank you Martin. I don't know how it got changed to manual but changing it to automatic solved the problem.

Thanks for your help

[prasadnknv]

Thank you. It worked.