Excel file runs slowly

Hi John_london,

Your statement of "some array formulas" is understated. You have 1122 array formulas on your first sheet. Rumor is that they are calculation hogs. As a matter of fact, I've never seen my i7 quad core CPU gauge pegged to the top with all 8 processors before. It took about a minute for me to load your work.

I'd send the workbook back to the developer and ask for a faster one. You might also ask for a faster computer if they expect you to use it. If you are the developer, my apologies

You have only one bad ref name in your workbook. Look at the Names Manager and try to delete the #Ref name.

Does any of this information help? I expect the reason for it being slow is the array formulas. Perhaps there is a workaround.