Copy formular

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?
 
B

Bernard Liengme

What is the formula that you are copying?
What does "reading the cell" mean?
best wishes
 
G

Gord Dibben

Your calculation mode is set to Manual.

Change to Automatic


Gord Dibben MS Excel MVP
 
S

Shane Devenshire

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.
 
Top