Formulas not being copied down - until cell is clicked into

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!
 
J

JS

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
 

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 formulas by scrolling 1
vlookup with all the same values in one column 2
Copying a formula with an increase of more than 1 6
Copy formula not working?! 4
Copying a cell down a column 5
Copy and Paste in Excel, copies cell and formula, but shows same v 3
Formula copying error 3
Copy formulas displaying wrong value 2

Top