

The runtime was less than 5 minutes (he was processing 200,000 rows of data). We had him reboot his PC and immediately try. We had a user tell us that one of our add-ins was taking 20-30 minutes to run.Under the general section, uncheck animation:

To turn off animation, do Office Button or File Tab then Options.We had one of our users discover that Excel animation was the cause. The first thing we do in Excel on a new PC is to turn animation off. However, it has probably always been there. Strangely, this is a new one to us as a cause of Excel problems.After removing COM add-ins it is best to reboot your PC.No time saving COM add-in is business essential if it causes Excel to slow down, hang, or crash. Then add back only those that are business essential.

The best approach is to uncheck any you see and see if Excel stops crashing, or at least becomes very stable. If you see Adobe or Bluetooth as COM add-ins, they almost always are never needed and just sneak onto PCs.
Download xlstat for excel 2013 how to#
How to Stop Microsoft Excel From Crashing
