Copy formular
 

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

Copy formular
 

What is the formula that you are copying?
What does "reading the cell" mean?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

Copy formular
 

Your calculation mode is set to Manual.

Change to Automatic


Gord Dibben MS Excel MVP

On Mon, 29 Dec 2008 09:25:02 -0800, 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?

Copy formular
 

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?