Performance issue with outline>subtotal function in Excel 2010
Posted on 2013-12-04
I have an employee in my office who uses the data functions in excel to prepare reports for upper management. Specifically, she sorts data using the Data>Outline>Subtotal function in excel. For some reason, when she initiates the process, the application processes the data ALARMINGLY slow. The problem is unique to her machine, as another employee tried it with the same file, and it zipped right through. Also of interest, when I launched her Excel in safe-mode, the processing also occurs much quicker on her machine. I have checked for add-ins, and it says that none are active. Anyone have any ideas what could be causing the slow down besides add-ins?