queenie

You can probably fix it by going to ToolsOptionsCalculation and selecting
"Automatic"


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 08:17:02 -0800, "queenie"
wrote:

I am now having a problem that has never happened before. When I copy a
formula from one cell to another, the copied cells show the value of the
original cell. I have tried the special paste option and that doesn't work
either. How can I fix this? Help