Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - How to print a large worksheet that is actually readable | Excel Discussion (Misc queries) | |||
Extracting data from large worksheet | Excel Worksheet Functions | |||
Having trouble printing a large worksheet | Setting up and Configuration of Excel | |||
VBA - How to parcel a large selection to avoid XL Crash | Excel Discussion (Misc queries) | |||
how do i save a large amount of data in a worksheet excel 4 | Excel Worksheet Functions |