Any way to speed up the opening of an Excel workbook?

BittenApple
BronzeLounger
Posts: 1478
Joined: 01 Mar 2015, 02:03

Any way to speed up the opening of an Excel workbook?

Post by BittenApple »

Hello team,
I have an Excel workbook that takes a long time to open due to many things that I have in the workbook. I wonder if there is any way to quicken the opening of the workbook like what we do in Microsoft Access.
Thanks,
BittenBitten

User avatar
HansV
Administrator
Posts: 74191
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Any way to speed up the opening of an Excel workbook?

Post by HansV »

You can delete unused rows and columns in each of the worksheets.
If possible, reduce the number and complexity of the formulas.

Or get a faster computer with more memory. An SSD instead of a spinning hard disk also helps... :evilgrin:
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1478
Joined: 01 Mar 2015, 02:03

Re: Any way to speed up the opening of an Excel workbook?

Post by BittenApple »

Thanks!!!