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?
LVL 9
Trenton KnewOwner / Computer WhispererAsked:
Who is Participating?
 
broro183Commented:
hi,

I don't think the calculation mode will stop CF from calculating either.

I did some Google searching & found some links that suggest using a "switch" as the first condition.

This post of Chip Pearson's gives a brief example:

Select the cells whose conditional formatting (CF) you wish to enable or disable. Then, decide on a cell whose value is to control this. Suppose that cell is B1. Open the CF dialog, add a new rule, select the "Formula Is" option and enter =NOT($B$1) as the condition. Move this rule to the top of the list of CF conditions. Check the "Stop If True" check box for this item.  Don't add any formatting. Now, if you enter TRUE in B1, conditional formatting will be applied as normal. If you enter FALSE in B1, no formatting is applied.
 
Note that this works only in Excel 2007 and later. It does not apply to Excel 2003 and earlier version.
Source of quote

Debra's article & comments give some similar examples.

hth
Rob
0
 
Trenton KnewOwner / Computer WhispererAuthor Commented:
Increased points to 500
0
 
JimFiveCommented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
broro183Commented:
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
0
 
Trenton KnewOwner / Computer WhispererAuthor Commented:
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?
0
 
JimFiveCommented:
You could try setting Calculate to Manual, but I'm not sure if that applies to conditional formatting.
0
 
Trenton KnewOwner / Computer WhispererAuthor Commented:
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.
0
 
broro183Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.