I work as an Excel Developer and owe a lot to Ozgrid and stackoverflow, which have become my go-to sites over the years. Never in all that time have I read a post addressing my particular problem. I also just did a couple of searches with the keywords "performance" and "freeze" which got a few hits but nothing directly related to my situation. Specifically (and I'm not exaggerating), 4 to 7 times a day Excel freezes up on me. Sometimes, even thought I can't even select anything on a spreadsheet, I can save my work before closing out of Excel and restarting. Too many times, however, the freeze is accompanied by a message that "Excel has stopped responding". When that happens, the only way I've found to get out of it is to end the task in Task Manager, in which case everything is lost back to my last save.
This has been going on for literally years. It happens at work with Excel 2010 running on a less-than powerful Lenovo PC, and at home with Excel 2016 running on an HP Envy 750-xt with an Intel Core [email protected] GHz processor and 32 GB of RAM. It's happened on at least my last 2 personal PC's and in other work situations. Since I can't find a trace of the same kind of problem here or on stackoverflow, where you'd figure at least 1 or 2 of the thousands of experienced Excel users would be grousing about it, I'm beginning to think it's either something I'm doing very wrong or I'm carrying some kind of Excel curse. Unfortunately, Microsoft tech support hasn't come up with anything they'll admit to.
If anyone has any information on this or a similar problem and, even better a potential solution, I'll be eternally grateful if you'd reply. Thanks in advance.