Forum Discussion
Excel File going to 40% and holding for up to 1 minute 8 seconds before opening.
I have a very large program I use for estimating (18,566KB). Program works well and does not require a lot of time to open (5 to 10 seconds). Made some changes to the program and increased it's siz...
Microsoft Excel has given lengthy document for improving opening file
Please take the points from the document which ever useful tips
https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions
Please take the points from the document which ever useful tips
https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions
Morning and thank you for the response. I have tried a few of these items, and update others as they become obvious. Unfortunately it becomes a balance between the time it would take to completely rewrite a program that grew over the past three years, vs. accepting a slower opening program. Ten... Fifteen seconds I can accept. One minute, eight seconds is a little excessive. I did find through trial and error that hiding unused cells seems to significantly speed up the opening process.