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.
 
You must log in or register to reply here.

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
Conditional Formating 1
paste without formular 1
How to seperate ALPHANUMERIC data in a cell in an excel sheet. 3
Excluding "0" in standard deviations 4
VLOOKUP FORMULA 1
Excel Rounding of Formular results 1

Back
Top