Hi,

In 2003 try
Tools, Options, Calculation, Automatic

In 2007 try
Formulas, Calculation Options, Automatic

There is also a possibility that the formula, which you have not shown us,
is in absolute notation =$G$1 for example. In that case change it to
relative =G1.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Benny" wrote:

When I copy my formular, even though its reading the cell, its giving me the
result of the original cell. Whats the probelem?