copying a formula, the reference adjusts, but the result does not

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

Guest

Why, when I copy a formula the reference adjusts as it should, but the result
does not change until I go into it again, making extra work. Is there some
kind of auto spreadsheet update that will do this for me at a click, or do I
need to change the way something is set up? The formula is, eg. =D60*3%.
 
It kind of sounds like you have calculation set to manual.

Tools|options|calculation Tab
change it to automatic
 
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

Copying a range of data without adjusting formulas 16
formula 3
Copying formulas using "+" cell reference causes r1c1 in linked sh 4
Copy a formula using Vlookup 2
Copy a relative reference formula from one sheet to another. 3
The formula shows in cell but not the result 1
Moving Formulas when Sorting 2
Reference Source Deleted & VBA ref adjustments 1

Back
Top