formulas won't fill by dragging
 

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

formulas won't fill by dragging
 

your calculatiosn are manual. got to Tools options Calculation and chaneg
to automatic.

"rjm8449" wrote:

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

formulas won't fill by dragging
 

that did it, thanks much

"Sean Timmons" wrote:

your calculatiosn are manual. got to Tools options Calculation and chaneg
to automatic.

"rjm8449" wrote:

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

formulas won't fill by dragging
 

"Sean Timmons" wrote:

your calculatiosn are manual. got to Tools options Calculation and chaneg
to automatic.

"rjm8449" wrote:

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

formulas won't fill by dragging
 

Excellent - thanks you. I was going crazy trying to figure out what was wrong!

"Sean Timmons" wrote:

your calculatiosn are manual. got to Tools options Calculation and chaneg
to automatic.

"rjm8449" wrote:

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