| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calc
I have a cell reference in a cell to a seperate sheet (e.g. =sheet2!c2) which
contains a simple addition formula (g1+g2+g3). The problem is that the totals are not automatically updating in the cell reference cell when there are changes in the sum sheet (g1_g2+g3+g4). I have to manually go in to the cell reference, then the totals will update. F9 doesn't update the sum--I still have to go into the cell to updated the total. I checked the calc settings which are automatic. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc
Tools Options Calculation tab select Automatic OK
"DStore" wrote: I have a cell reference in a cell to a seperate sheet (e.g. =sheet2!c2) which contains a simple addition formula (g1+g2+g3). The problem is that the totals are not automatically updating in the cell reference cell when there are changes in the sum sheet (g1_g2+g3+g4). I have to manually go in to the cell reference, then the totals will update. F9 doesn't update the sum--I still have to go into the cell to updated the total. I checked the calc settings which are automatic. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc
I have calc set to Automatic (in both sheets) as I referenced in my original
post. "Teethless mama" wrote: Tools Options Calculation tab select Automatic OK "DStore" wrote: I have a cell reference in a cell to a seperate sheet (e.g. =sheet2!c2) which contains a simple addition formula (g1+g2+g3). The problem is that the totals are not automatically updating in the cell reference cell when there are changes in the sum sheet (g1_g2+g3+g4). I have to manually go in to the cell reference, then the totals will update. F9 doesn't update the sum--I still have to go into the cell to updated the total. I checked the calc settings which are automatic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calc | Excel Worksheet Functions | |||
| Code to calc | Excel Discussion (Misc queries) | |||
| My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
| =If - how to tell it to calc certain %'s only | Excel Worksheet Functions | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
Linear Mode
