| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| Excel Formulas | Excel Discussion (Misc queries) | |||
| 3D formulas in Excel | Excel Worksheet Functions | |||
| EXCEL FORMULAS | Excel Worksheet Functions | |||
Linear Mode
