View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default 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