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.
 

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

Sheet Names and Auto-calculation 2
Excel Drag autofill only part of formula 3
Drag formula - ignore blank cells 1
Fill Series for Lookup 2
Linking Formula 2
Fill Options & Formula Help 2
Filling Formulas 2
Dragging/Copying Formulas in Excel 2007 3

Back
Top