Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Calculation obstacle
I have created a spreadsheet for a monthly tracking task in our office. There
are 31 worksheets which contain daily numbers. I have done basic calculations (adding columns within the day) as well as calculations from one page to the next (for tracking MTD totals). I have done this type of spreadsheet several times in the past with no problems. The problem I am running in to is that the calculations are not automatically completed when a number is inserted or changed. For example if I am totalling 4 cells and i change a number in one of those cells, the sum does not change unless I double click in the cell that contains the formula for the sum and hit enter. Way Weird! I am using Excel 2003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Calculation obstacle
check tools-options-calculation asn set for automatic
"Florida Karen" wrote: I have created a spreadsheet for a monthly tracking task in our office. There are 31 worksheets which contain daily numbers. I have done basic calculations (adding columns within the day) as well as calculations from one page to the next (for tracking MTD totals). I have done this type of spreadsheet several times in the past with no problems. The problem I am running in to is that the calculations are not automatically completed when a number is inserted or changed. For example if I am totalling 4 cells and i change a number in one of those cells, the sum does not change unless I double click in the cell that contains the formula for the sum and hit enter. Way Weird! I am using Excel 2003 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Calculation obstacle
Did your autocalculation get turned off?
go to 'tools'....'options'....'calculation' and make sure the auto calc check box is checked. "Florida Karen" wrote: I have created a spreadsheet for a monthly tracking task in our office. There are 31 worksheets which contain daily numbers. I have done basic calculations (adding columns within the day) as well as calculations from one page to the next (for tracking MTD totals). I have done this type of spreadsheet several times in the past with no problems. The problem I am running in to is that the calculations are not automatically completed when a number is inserted or changed. For example if I am totalling 4 cells and i change a number in one of those cells, the sum does not change unless I double click in the cell that contains the formula for the sum and hit enter. Way Weird! I am using Excel 2003 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Calculation obstacle
Experienced a similar issue a few weeks ago. I kept checking and rechecking
the "automatic" calculation check box in ToolsOptionsCalculation with teh same results you describe. Finally I noticed that several worksheet tabs were lioght gray. Evidently I had inadvertently selected multiple worksheets, and Excel will not perform an automatic calculation while multiple worksheets are selected. HTH "Florida Karen" wrote: I have created a spreadsheet for a monthly tracking task in our office. There are 31 worksheets which contain daily numbers. I have done basic calculations (adding columns within the day) as well as calculations from one page to the next (for tracking MTD totals). I have done this type of spreadsheet several times in the past with no problems. The problem I am running in to is that the calculations are not automatically completed when a number is inserted or changed. For example if I am totalling 4 cells and i change a number in one of those cells, the sum does not change unless I double click in the cell that contains the formula for the sum and hit enter. Way Weird! I am using Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
this is probably very basic | Excel Discussion (Misc queries) | |||
Basic If | Excel Worksheet Functions | |||
DV basic help | New Users to Excel | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |