| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speed up performance for very big array
I have used all the possible techniques in Excel to improve its
performance including what you have mentioned. My computer was hung when the first version ran. Now it takes about 10 to 70 seconds depending on how complex the calculation formulas are. I am using evaluate method to get the result of each formula. However, the problem was still the same even if I avoided using this methods. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Speed of array formula | Excel Worksheet Functions | |||
| charting performance speed | Charts and Charting in Excel | |||
| Excel Speed Performance help | Excel Discussion (Misc queries) | |||
| Worksheet speed with array formula | Excel Discussion (Misc queries) | |||
| VBA - speed up macro, working with array? | Excel Programming | |||
Threaded Mode
