Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Speeding up Excel calculations
Hi All,
I have a workbook with a lot of array functions. To give an idea: - 17 sheets of which 15 with about 150 array functions per sheet - 1 sheet contains the raw data, 10,000 rows - I have to use array functions because several conditions have to be checked It is all working fine, the only thing is that it takes 30 minutes or more to recalculate the workbook. So, you can imagine that I try to avoid recalculations as much as possible. Does one have some good tips to speeding up Excel? With kind regards, JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speeding up Excel 2003 | Excel Discussion (Misc queries) | |||
Speeding up calculations | Excel Discussion (Misc queries) | |||
Speeding Up A Spreadsheet | Excel Discussion (Misc queries) | |||
Speeding up workbook calculations | Excel Discussion (Misc queries) | |||
Speeding Saving Process | Excel Discussion (Misc queries) |