On Jul 1, 4:52*am, dr wrote:
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.

Try to open any other small file and see if you face the same problem.
Try opening a file with only one cell containing data text.

Is this also give same problem?

Regards,
Madiya.