I created a workbook with two main sections 400 rows, 40 coumns with
data being retrieved usning CUBE formulas. I have about 15 macros in
the spreadsheet and another sheet that uses alot of vlookups. It
takes over about 15 minutes to open the workbook, but a few seconds to
save and close. Excel opens up right away, it is just this file.
Once the file is open there is no speed issues at all.