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...
Update!!! Just figured it out. Hide the cells! I had a large amount of cells hidden. Some of the cells contained formulas. If I have them unhidden the program stops at 40%. Hide them, it opens quickly.
- 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-obstructionsMorning 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.
