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!
 
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
 
Back
Top