View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Henry Henry is offline
external usenet poster
 
Posts: 61
Default Why does it take so long to open?

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?