Trenton Knew
asked on
Performance issue with outline>subtotal function in Excel 2010
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?
I don't have any good ideas but I would look at the calculation settings in File | Options | Formulas
I would also check to see if there is a macro workbook being loaded. Perhaps there is a macro that duplicates a function name being used in the worksheet being processed.
I would also look at whether the workbook has links to other workbooks, especially those on a network.
Good Luck
I would also check to see if there is a macro workbook being loaded. Perhaps there is a macro that duplicates a function name being used in the worksheet being processed.
I would also look at whether the workbook has links to other workbooks, especially those on a network.
Good Luck
I think Jim's suggestions are good ideas, I'll try from another angle:
- What view is being used eg is it displayed using "pagebreak preview"?
- Is the zoom level at 100%?
- This is unlikely but I'll ask anyway. Are all machines using the same version of printer driver?
Can they be updated?
- Do they have the same default printer?
- Are all machines on the same version of Office & do they have the same Service Packs applied?
Rob
- What view is being used eg is it displayed using "pagebreak preview"?
- Is the zoom level at 100%?
- This is unlikely but I'll ask anyway. Are all machines using the same version of printer driver?
Can they be updated?
- Do they have the same default printer?
- Are all machines on the same version of Office & do they have the same Service Packs applied?
Rob
ASKER
Follow up, We found that removing conditional formatting rules from the spreadsheet SIGNIFICANTLY boosted performance with inserting subtotals. Anyone know a way to make the spreadsheet not apply formats until the operation completes?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I appreciate you two helping with this. The person I was trying to help was a little too on the impatient side for me to try the formats on/off tbing. she was able to get her work done, so, I'm splitting the points for effort. Thanks again.
Thank you for the points :-)
If you do get a chance to try any of our suggestions in the future please let us know if they help
Rob
If you do get a chance to try any of our suggestions in the future please let us know if they help
Rob
ASKER