Excel 2010: Sort is slower and causes errors after MS12-030

Article ID: 2716388 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

After you install MS12-030 (Vulnerabilities in Microsoft Excel could allow remote code execution - http://support.microsoft.com/kb/2663830) you may see an error message or have slow performance when sorting data in a worksheet.

The Sort may fail with the following error and then Excel can be unstable due to lack of resources.

Excel cannot complete this task with available resources. Choose less data or close other applications.


On 64 bit Excel 2010 the sort may finish but will take a considerably longer time to finish the sort. 

Depending on the number of rows selected you may see the following alert.

The operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. Are you sure you want to continue?

This problem happens when you select all of the cells in the worksheet (clicking the Select All button or ctrl+a to select all cells) or entire rows of cells before you sort your data. 

Note: Microsoft does not recommend choosing the Select All button before sorting. When Select All Button is chose the user is selecting over 17 billion cells. 

CAUSE

Microsoft is currently investigating this issue to be addressed in futue Cumulative Update HotFix. 

You can find the latest Cumulative Updates for Office and what issues were fixed in them using the following KB article.

953878 Cumulative updates are available from the Microsoft Office team to fix reported problems
http://support.microsoft.com/kb/953878/EN-US

RESOLUTION

Installing the latest CU for Excel will resolve the issue with sorting.

2598378 Description of the Excel 2010 hotfix package (excel.msp, graph.msp): June 26, 2012


MORE INFORMATION


A best practice when sorting is allow Excel to automatically detect your sort range by placing your mouse cursor in the table and selecting sort. You can also use ctrl+* (ctrl+shift+8) to have Excel select the current region before sorting. If your range has empty rows or columns in it you may need to select the specific range manually before sorting.

Note: If you have a Defined Name 'Database' Excel will select that range rather than auto detecting the current region.


If you are sorting cells in a VBA macro you should specify the range of cells to be sorted in your code.

291308 How to select cells/ranges by using Visual Basic procedures in Excel
http://support.microsoft.com/kb/291308/EN-US
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2716388 - Last Review: June 28, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft Excel 2010
Keywords: 
KB2716388

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com