Copied formula shows original value until clicking in formula bar

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
Check to see if Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"

HTH,
Elkar
 
Back
Top