Excel Sum Formulas - maybe all??
 

I just got set up with Office 2007. I was creating some spreadsheets and
found that I can't just copy formulas over. I fill in a sum formula, and
then drag the content over and it changes the cell range okay, but it doesn't
update the amount. Also, if I change the numbers within the formula it
doesn't update the total. Is there something I've done wrong?

Excel Sum Formulas - maybe all??
 

xanthippe09 wrote...
I just got set up with Office 2007. I was creating some spreadsheets
and found that I can't just copy formulas over. I fill in a sum
formula, and then drag the content over and it changes the cell range
okay, but it doesn't update the amount. Also, if I change the numbers
within the formula it doesn't update the total. Is there something
I've done wrong?

Press [F9] to see if that produces the correct results. If it does,
your problem is that Excel is set for manual recalculation. And, very
unfortunately, that means you have to wade through Excel 2007's much
less efficient Options dialog. I don't have Excel 2007, so I can't
give you the steps to follow, but you should be able to find out using
Excel online help, searching for the term Calculation.

Excel Sum Formulas - maybe all??
 

Round Office buttonExcel optionsFormulasWorkbook Calculationtick
Automatic

--
Regards

Roger Govier


"Harlan Grove" wrote in message
oups.com...
xanthippe09 wrote...
I just got set up with Office 2007. I was creating some spreadsheets
and found that I can't just copy formulas over. I fill in a sum
formula, and then drag the content over and it changes the cell range
okay, but it doesn't update the amount. Also, if I change the numbers
within the formula it doesn't update the total. Is there something
I've done wrong?

Press [F9] to see if that produces the correct results. If it does,
your problem is that Excel is set for manual recalculation. And, very
unfortunately, that means you have to wade through Excel 2007's much
less efficient Options dialog. I don't have Excel 2007, so I can't
give you the steps to follow, but you should be able to find out using
Excel online help, searching for the term Calculation.

Excel Sum Formulas - maybe all??
 

If it were a snake, it would have bitten me! <vbg

Roger Govier wrote:

Round Office buttonExcel optionsFormulasWorkbook Calculationtick
Automatic

--
Regards

Roger Govier

"Harlan Grove" wrote in message
oups.com...
xanthippe09 wrote...
I just got set up with Office 2007. I was creating some spreadsheets
and found that I can't just copy formulas over. I fill in a sum
formula, and then drag the content over and it changes the cell range
okay, but it doesn't update the amount. Also, if I change the numbers
within the formula it doesn't update the total. Is there something
I've done wrong?

Press [F9] to see if that produces the correct results. If it does,
your problem is that Excel is set for manual recalculation. And, very
unfortunately, that means you have to wade through Excel 2007's much
less efficient Options dialog. I don't have Excel 2007, so I can't
give you the steps to follow, but you should be able to find out using
Excel online help, searching for the term Calculation.


--

Dave Peterson

Excel Sum Formulas - maybe all??
 

Thanks! I had installed it on my home comp and it worked fine there. So
when it didn't work for me at work...lol

"Roger Govier" wrote:


Round Office buttonExcel optionsFormulasWorkbook Calculationtick
Automatic

--
Regards

Roger Govier


"Harlan Grove" wrote in message
oups.com...
xanthippe09 wrote...
I just got set up with Office 2007. I was creating some spreadsheets
and found that I can't just copy formulas over. I fill in a sum
formula, and then drag the content over and it changes the cell range
okay, but it doesn't update the amount. Also, if I change the numbers
within the formula it doesn't update the total. Is there something
I've done wrong?

Press [F9] to see if that produces the correct results. If it does,
your problem is that Excel is set for manual recalculation. And, very
unfortunately, that means you have to wade through Excel 2007's much
less efficient Options dialog. I don't have Excel 2007, so I can't
give you the steps to follow, but you should be able to find out using
Excel online help, searching for the term Calculation.