View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cox cox is offline
external usenet poster
 
Posts: 3
Default Avoid recomputation in a large excel worksheet

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?