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