formulas won't fill by dragging

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
 
S

Sean Timmons

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

Help Fill Series 1
Sheet Names and Auto-calculation 2
Copy column, paste special formulas & number formats doesn't work 3
Problem dragging formulas 1
Copying formulas by dragging fill box 5
Can fill handle be moved without mouse dragging? 4
backing up formulas in sheet coding? 2
Fill function with file reference 0

Top