X
xirx
Hi!
I am working with rather huge tables in Excel. Due to the formulas,
recalculation comsumes a reasonable amount of time. I would like to
understand why Excel does recalculation and if there is a way to interrupt
it.
First, my picture of the recalculation scheme is that if a cell C1 depends
on the values of the values in A1 and B1 (e.g. C1's contains "=A1+B1"), C1
needs to be recalculated (and thus _is_ recalculated) only if the value of
either A1 or B1 (or both) is updated.
[As I am using match/index functions on rather huge tables, updating all
values often takes reasonable amount of time. If the machine starts
swapping, I'd like to interrupt the calculation. Is there any way to do
this?]
But I am observing cases in which insert a new column and enter a simple
formula that refers to existing values, only (of course). But Excel starts
recalculation of the complete sheet. Well, that's a guess, only. But
calculation of the new columns values can't take that amount of time...
So, is my picture of Excel's recalculation scheme wrong? How does Excel
determine if a cells's values needs to be recalculated?
[Yes, I know that I can disable atomatic recalculation. However, I manual
recalculation will enforce recalcualtion of _all_ values, while automatic
recalculation should trigger only required cell updated. So, in the long
run, automatic recalculation should be the less time consuming way to
work...]
Any coments appreciated...
I am working with rather huge tables in Excel. Due to the formulas,
recalculation comsumes a reasonable amount of time. I would like to
understand why Excel does recalculation and if there is a way to interrupt
it.
First, my picture of the recalculation scheme is that if a cell C1 depends
on the values of the values in A1 and B1 (e.g. C1's contains "=A1+B1"), C1
needs to be recalculated (and thus _is_ recalculated) only if the value of
either A1 or B1 (or both) is updated.
[As I am using match/index functions on rather huge tables, updating all
values often takes reasonable amount of time. If the machine starts
swapping, I'd like to interrupt the calculation. Is there any way to do
this?]
But I am observing cases in which insert a new column and enter a simple
formula that refers to existing values, only (of course). But Excel starts
recalculation of the complete sheet. Well, that's a guess, only. But
calculation of the new columns values can't take that amount of time...
So, is my picture of Excel's recalculation scheme wrong? How does Excel
determine if a cells's values needs to be recalculated?
[Yes, I know that I can disable atomatic recalculation. However, I manual
recalculation will enforce recalcualtion of _all_ values, while automatic
recalculation should trigger only required cell updated. So, in the long
run, automatic recalculation should be the less time consuming way to
work...]
Any coments appreciated...