excel formulas not copying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am copying a relative formula from one cell to another. when i paste the
copy i get the same answer as the original cell. this happens with a new
file and different computer/program. when i hilite the clone cell and hit
return, the correct answer shows. the formula is simple and is generated
from the formula wizard (i.e.: ln(A5)). the answer for the A5 reference
shows up in all clones cells.
 
You probably have Calculation set to manual. You can hit F9 to recalculate
at any time. Or, you can set Calculation to automatic.

Tools-Options-Calculation (tab)...select Automatic.

HTH,
Paul
 
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

Hide columns based on row values 2
Create a formula by joining text and the value from a formula 3
Use Formula from another worksheet 3
Average formula 2
help with formula for last input in column 6
COPYING FORMULAE 1
Formula 5
Making COUNTIF update in real time 4

Back
Top