(Excel 2010, Win 7, 10GB RAM): I have a complex workbook, 4MB on disk, that takes 3-4 full minutes to load from disk. The main worksheet's workhorse range is 30 rows by 90 columns, many with lengthy formulas, and many columns have 5 or 6 conditional formatting criteria.
After it's in RAM, it recalcs reasonably quickly (3 sec), so my question is about why it takes so long to load from disk. Because recalc happens quickly, I suspect the conditional formatting (not the formulas) is what causes the initial load-from-disk to take 3+ minutes.
Just curious if anyone has some experience with similarly long load times due to conditional formatting complexity (or numerous complex formulas).