Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalculate changes only
I have on my Excel 2000 workbook some complex calculations. According to
Help, Excel "recalculates those cells that are dependent on other cells that contain values that have changed." However, when I change cells on which the complex calculations do not depend (or even if I simply apply the format paintbrush to keep grouped columns the same width) it takes half a minute, the same as when it recalculates the whole workbook. I have set the calculation to Automatic, so that the non-complex formulas get recalculated when I change their precedent cells. Based on the information in Help, however, I believe that Excel is supposed to calculate dependents only of changed cells, even in Automatic. How can I prevent recalculation of cells whose precedents are unchanged? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalculate changes only
Excel recalculates both volatile cells and their dependents and changed
cells and their dependents. Probably you have some volatile functions somewhere (OFFSET is volatile) Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "hmm" wrote in message ... I have on my Excel 2000 workbook some complex calculations. According to Help, Excel "recalculates those cells that are dependent on other cells that contain values that have changed." However, when I change cells on which the complex calculations do not depend (or even if I simply apply the format paintbrush to keep grouped columns the same width) it takes half a minute, the same as when it recalculates the whole workbook. I have set the calculation to Automatic, so that the non-complex formulas get recalculated when I change their precedent cells. Based on the information in Help, however, I believe that Excel is supposed to calculate dependents only of changed cells, even in Automatic. How can I prevent recalculation of cells whose precedents are unchanged? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalculate changes only
In addition to Charles' comments, when a workbook reaches a sufficiently
high level of complexity Excel no longer tries to track the cell dependencies that permit minimal recalc. http://support.microsoft.com/kb/243495/en-us -- Jim "hmm" wrote in message ... |I have on my Excel 2000 workbook some complex calculations. According to | Help, Excel "recalculates those cells that are dependent on other cells that | contain values that have changed." However, when I change cells on which the | complex calculations do not depend (or even if I simply apply the format | paintbrush to keep grouped columns the same width) it takes half a minute, | the same as when it recalculates the whole workbook. | | I have set the calculation to Automatic, so that the non-complex formulas | get recalculated when I change their precedent cells. Based on the | information in Help, however, I believe that Excel is supposed to calculate | dependents only of changed cells, even in Automatic. | | How can I prevent recalculation of cells whose precedents are unchanged? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalculate changes only
Thanks Charles.
I use the INDIRECT.EXT function, one of whose parameters allows for making it non-volatile. I used this feature to significantly reduce the re-calculation time. "Charles Williams" wrote: Excel recalculates both volatile cells and their dependents and changed cells and their dependents. Probably you have some volatile functions somewhere (OFFSET is volatile) Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "hmm" wrote in message ... I have on my Excel 2000 workbook some complex calculations. According to Help, Excel "recalculates those cells that are dependent on other cells that contain values that have changed." However, when I change cells on which the complex calculations do not depend (or even if I simply apply the format paintbrush to keep grouped columns the same width) it takes half a minute, the same as when it recalculates the whole workbook. I have set the calculation to Automatic, so that the non-complex formulas get recalculated when I change their precedent cells. Based on the information in Help, however, I believe that Excel is supposed to calculate dependents only of changed cells, even in Automatic. How can I prevent recalculation of cells whose precedents are unchanged? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions | |||
how do I turn ON auto REcalculate for formulas if new data enter? | Excel Worksheet Functions | |||
Can you recalculate an individual excel cell in isolation? | Excel Worksheet Functions | |||
Auto recalculate? | Excel Worksheet Functions | |||
function does not recalculate sum | Excel Worksheet Functions |