Slow loading of LARGE workbood

Folks,
I have an extremely large worksbook with over 350 worksheets and over 5.5mb. There are tons of macros I use. It taker a long time to load. I need opinions tgo speed up loading the workbook. I'm considering placing this code when the workbook launaches:

Application.Calculation = xlCalculationManual

and place this code when the worksheet launches and closes:

Application.Calculation = xlCalculationAutomatic
Application.Calculation = xlCalculationManual
Frank FreeseAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
You could try one or both of these:

Delete all unnecessary rows at the bottom of all sheets
Save the file in xlsb format
0
 
piattndConnect With a Mentor Commented:
Is the excel file on your local machine or is it on a network share?  Do you have it performing any actions when you first launch the excel file?  If so, does it speed things up if you trigger these via a button instead of the load?
0
 
Frank FreeseAuthor Commented:
The file is on a local drive.
Nothing out of the ordinary when the workbook first launches.
I did a test and when I launch the workbook with maunal calculation the file took 2:15 to load rather than 3:21 seconds.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Frank FreeseAuthor Commented:
OK Martin - I'l look at that tonight
0
 
Frank FreeseAuthor Commented:
Martin,
There was a significant difference in the how file loads. I'm still building my Excel Formula and Functions workbook after all this time so you have some idea on the project you helped me with.
Thanks,
Frank
0
 
Frank FreeseAuthor Commented:
Thank you very much folks!
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help. Which of my two suggestions helped?

Marty - MVP 2009 to 2013
0
 
Frank FreeseAuthor Commented:
The xlsb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.