Excel Sum Formulas - maybe all??

[xanthippe09]

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?

 

[Harlan Grove]

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.

 

[Roger Govier]

Round Office button>Excel options>Formulas>Workbook Calculation>tick
Automatic

--
Regards

Roger Govier

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]

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

Round Office button>Excel options>Formulas>Workbook Calculation>tick
Automatic

--
Regards

Roger Govier

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.

 

[xanthippe09]

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

Round Office button>Excel options>Formulas>Workbook Calculation>tick
Automatic

--
Regards

Roger Govier

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.