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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMULAR REDIRECT 4
Cell formular 2
How to seperate ALPHANUMERIC data in a cell in an excel sheet. 3
paste without formular 1
FORMULAR TO INSERT DATA FROM ONE CELL TO ANOTHER 1
How do i copy a vlookup formula into other cells going right 1
Excluding "0" in standard deviations 4
VLOOKUP FORMULA 1

Top