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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoid recomputation in a large excel worksheet
This macro will convert the formulas to values for whatever selection you
make. It could be designed to do the selection for you Sub converttovalues() With Selection ..Value = .Value End With End Sub It could be designed to do without selections but you may want to retain some formulas Sub converttovalues2() With ActiveSheet.UsedRange ..Value = .Value End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "cox" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |