Hello Message Board,
I have been dealing with an excel issue for several months. Here’s the backstory:
I have a project progress reporting tool that uses EVM (earned value management) principles.
The issues is this: The workbook(s) start out in a normal fashion, specifically open, save and close don’t take noticeable time to execute. Over time and with only small to moderate data entries/changes, the workbook(s) begin to take longer and longer to Open, Save and Close. And they also begin to bloat in size starting out at 1-2MB and growing to 50+MB. The O, S and C times increase from seconds to literally many hours. The files failed to upload (size <4MB) but i would be happy to send a cloud link or the files themselves for anyone interested in seeing this for real. Caveat: open these files in separate instances of Excel so as not to corrupt any other open Excel files. I would be most appreciative of any info as to the cause of the irritating and perplexing situation…thanks in advance…
Bookmarks