Sep 05 2022 07:22 AM
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 size to (21,145KB). Now the program get's to 39 to 40% and holds for over one minute before opening (1 minute 12 seconds at most). I don't believe it's the size because I deleted some pages to get it smaller, and it still hangs. This leads me to believe its a coding issue. I went back to older revisions and tried to make one change at a time to try and find the issue without success. Most of the time it hangs at 39%, then says "accessing printer". I tried to save the file to default to PDF. Again, without success. I am running Windows 11. I have done all the updates. I tried to save it on my computer vs. cloud and nothing seems to matter. How can I possibly trouble shoot this? This is a Macro-Enabled Worksheet. Macro part of the workbook has not changed from earlier versions (ones that open quickly).
Sep 05 2022 08:18 AM
Sep 06 2022 03:17 AM
Sep 06 2022 03:51 AM
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.