| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
why doesnt my formula cell update automatically ?
=SUM(G5:G11) if I change any cell in the range, the sum is not performed. I
have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#2
|
|||
|
|||
|
Check and make sure that calculation is set to automatic.
ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#3
|
|||
|
|||
|
Thanks Biff...not sure how it got set to manual!
"Biff" wrote: Check and make sure that calculation is set to automatic. ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#4
|
|||
|
|||
|
Hi Wozza
FYI the calculation mode is set by the Calculation setting of the first Workbook opened in that session of Excel. Maybe the first book you opened was from someone else, and they had the calculation set to manual. Regards Roger Govier Wozza wrote: Thanks Biff...not sure how it got set to manual! "Biff" wrote: Check and make sure that calculation is set to automatic. ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why doesnt my formula cell update automatically ?
I would love to know why Excel does this as I have had the same problem today
and its a workbook that we have used everyday this month and it is used by the same person everytime, then for some reason, this morning it has somehow set itself to Manual Calculation. Anyone got any ideas? "Roger Govier" wrote: Hi Wozza FYI the calculation mode is set by the Calculation setting of the first Workbook opened in that session of Excel. Maybe the first book you opened was from someone else, and they had the calculation set to manual. Regards Roger Govier Wozza wrote: Thanks Biff...not sure how it got set to manual! "Biff" wrote: Check and make sure that calculation is set to automatic. ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why doesnt my formula cell update automatically ?
Ruth, the easiest workaround is to just have the workbook set calculation to
automatic every time it is opened. Copy the 3 lines of code below, open the workbook, right-click on the Excel icon at the left of the menubar and select View Code. Paste the code in there. Press Alt-F11 to return to the spreadsheet. Close the file and save it. Now when it's opened, calculation will be automatic. HTH, James Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic End Sub "Ruth" wrote in message ... I would love to know why Excel does this as I have had the same problem today and its a workbook that we have used everyday this month and it is used by the same person everytime, then for some reason, this morning it has somehow set itself to Manual Calculation. Anyone got any ideas? "Roger Govier" wrote: Hi Wozza FYI the calculation mode is set by the Calculation setting of the first Workbook opened in that session of Excel. Maybe the first book you opened was from someone else, and they had the calculation set to manual. Regards Roger Govier Wozza wrote: Thanks Biff...not sure how it got set to manual! "Biff" wrote: Check and make sure that calculation is set to automatic. ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why doesnt my formula cell update automatically ?
"Zone" wrote: Ruth, the easiest workaround is to just have the workbook set calculation to automatic every time it is opened. Copy the 3 lines of code below, open the workbook, right-click on the Excel icon at the left of the menubar and select View Code. Paste the code in there. Press Alt-F11 to return to the spreadsheet. Close the file and save it. Now when it's opened, calculation will be automatic. HTH, James Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic End Sub "Ruth" wrote in message ... I would love to know why Excel does this as I have had the same problem today and its a workbook that we have used everyday this month and it is used by the same person everytime, then for some reason, this morning it has somehow set itself to Manual Calculation. Anyone got any ideas? "Roger Govier" wrote: Hi Wozza FYI the calculation mode is set by the Calculation setting of the first Workbook opened in that session of Excel. Maybe the first book you opened was from someone else, and they had the calculation set to manual. Regards Roger Govier Wozza wrote: Thanks Biff...not sure how it got set to manual! "Biff" wrote: Check and make sure that calculation is set to automatic. ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why doesnt my formula cell update automatically ?
"Roger Stone" wrote: Is this in Office 2007? I can't get any Code view open. Am I clicking the wrong thing? "Zone" wrote: Ruth, the easiest workaround is to just have the workbook set calculation to automatic every time it is opened. Copy the 3 lines of code below, open the workbook, right-click on the Excel icon at the left of the menubar and select View Code. Paste the code in there. Press Alt-F11 to return to the spreadsheet. Close the file and save it. Now when it's opened, calculation will be automatic. HTH, James Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic End Sub "Ruth" wrote in message ... I would love to know why Excel does this as I have had the same problem today and its a workbook that we have used everyday this month and it is used by the same person everytime, then for some reason, this morning it has somehow set itself to Manual Calculation. Anyone got any ideas? "Roger Govier" wrote: Hi Wozza FYI the calculation mode is set by the Calculation setting of the first Workbook opened in that session of Excel. Maybe the first book you opened was from someone else, and they had the calculation set to manual. Regards Roger Govier Wozza wrote: Thanks Biff...not sure how it got set to manual! "Biff" wrote: Check and make sure that calculation is set to automatic. ToolsOptionsCalculation Biff "Wozza" wrote in message ... =SUM(G5:G11) if I change any cell in the range, the sum is not performed. I have to select the sum cell, F2 then Enter in order to get the sum to work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Can I set up the formula to update automatically? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
