Copied formula shows original value until clicking in formula bar

G

Guest

This is a recent error, not sure if I've hit a bug or some weird setting I
accidently turned on. When I drag a formula down the sheet the value
displayed in the new cells stays the same as the original cell, but when you
click the formula bar, the formulas are correctly changed. Only when I click
in the formula bar and then hit enter does the cell recalculate and display
the correct value. This takes away all the benefit of dragging the formula
in the first place. PLEASE HELP!
 
G

Guest

Check to see if Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"

HTH,
Elkar
 

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

Formula appearing as Value in Formula Bar 1
Why does a copied formula display the original answer? 2
Excel 2007: Flickering formula bar after data entry + CPU up to 50 4
Copying an Array formula 3
copied cell shows original value 2
Formula not getting copied to entire column 0
space bar to clear a cell we get #value! 1
Cell contents in formula bar 9

Top