Most common cause of this is that calculation is set to manual.

ToolsOptionsCalculation.

Set it to Automatic.


Gord Dibben MS Excel MVP

On 21 Feb 2007 12:56:28 -0800, wrote:

When I copy and paste formulas, the relative cell referencing is not
working. It is copying the same formula all the way down and I don't
have any absolutes in my formulas. What could be the problem?