Frank Freese
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK Martin - I'l look at that tonight
ASKER
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
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
ASKER
Thank you very much folks!
You're welcome and I'm glad I was able to help. Which of my two suggestions helped?
Marty - MVP 2009 to 2013
Marty - MVP 2009 to 2013
ASKER
The xlsb
ASKER
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.