Formulas not being copied down - until cell is clicked into

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

My problem is that when I copy a formula in excel the
formula appears to have copied down the column correctly
but it outputs the wrong answer. It is not until I
actually click in to the cell (doubleclicking or F2) and
then click enter that the correct value appears.

WEIRD!

Please advise!
 
Go to tools options calculation and make calculation
automatic.

Alan
 
Have you checked if calculation is automatic? Press F9 - if they update
then your calculation is manual. Go to Tools - Option - Calculation Tab and
set 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

Copy formula not working?! 4
Copying formulas by scrolling 1
why does formula not work until I clear referenced cell ?? 3
Copying a cell down a column 5
vlookup with all the same values in one column 2
Copy and Paste in Excel, copies cell and formula, but shows same v 3
Formula copying error 3
Formulas won't increment when dragging to adjacent cells? 3

Back
Top