formulas won't fill by dragging

  • Thread starter Thread starter rjm8449
  • Start date Start date
R

rjm8449

version 2003, working in the same workbook now for quite some time, has
stopped the ability to click and drag the formulas down the sheet, only
copies the value of the first cell. i also noticed that the sheet will not
update formula calculations now until i save (F9). probably related to each
other, i just can't seem to pinpoint it.

thanks for any help
randy
 
your calculatiosn are manual. got to Tools > options > Calculation and chaneg
to automatic.
 
Back
Top