Avoid recomputation in a large excel worksheet
Maybe it's your formula that needs to be reviewed?
You may want to post it to see if anyone can help.
cox wrote:
I have a worksheet with 2000 rows and 20 columns. All of these cells have
formula to compute their values. Each formula gets recomputed even when the
data used the computation have not changed - in short it takes an enormous
time to recompute 40000 data whose values have not changed. Is there anyway
to make excel stop recomputation when it is known that the values will not
change, because none of those cells whose values are used in computation has
been updated?
--
Dave Peterson
|