Henry wrote:
I have this huge complicated template, 94 Mbs its not a format issue, more a
complex long string of nested IF statements. The problem is that opening the
file takes about 15 mins.. not kidding. Saving the file takes about 5 mins.
Calc the file takes about 5 mins, even if I change all the variables.
My question is why does it take that long to open? The file is on my local
HD, so you would think it would be faster. Can someone explain?

Excel version?
How much free memory?
How fast is your processor?
Short on HD space?
94 mb is somewhat excessive. There must be some way to clean up your logic.

Bill