ToolsOptionsCalculation in "Manual" mode?

Change to Automatic.

Post the formula and show us what is in the referenced cells.


Gord Dibben MS Excel MVP


On Fri, 7 Jul 2006 14:54:02 -0700, Jasim Al-Ajmi
wrote:

After copying a fomula in excel, I ended up with the proper formula, however,
it copied the value of the cell from which I have copied the fomula.

When I tried to create the formula instead of copying it, I ended up with
zaro.