Copy formular

  • Thread starter Thread starter Benny
  • Start date Start date
B

Benny

When I copy my formular, even though its reading the cell, its giving me the
result of the original cell. Whats the probelem?
 
What is the formula that you are copying?
What does "reading the cell" mean?
best wishes
 
Your calculation mode is set to Manual.

Change to Automatic


Gord Dibben MS Excel MVP
 
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.
 
Back
Top