Select the product you need help with

An error occurs when you try to sort the rows in a whole worksheet in Excel 2010

Article ID: 2687317 - View products that this article applies to.

Symptoms

When you select a whole worksheet and then try to sort the rows in Microsoft Excel 2010, you receive the following error message:

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

Note This issue specifically occurs after you apply the update that is described in the following Microsoft Knowledge Base (KB) article:

2663830

(http://support.microsoft.com/kb/2663830/ )

MS12-030: Vulnerabilities in Microsoft Excel could allow remote code execution: May 8, 2012

Back to the top | Give Feedback

Resolution

To resolve this issue, apply the following hotfix package:

2598378

(http://support.microsoft.com/kb/2598378/ )

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

Registry key information

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756

(http://support.microsoft.com/kb/322756/ )

How to back up and restore the registry in Windows

After you install the hotfix package, the following issue that is described in KB 2597010 will occur:

When you change the height of a row that contains data in Excel 2010, and then you sort a column that contains data, the height change is not applied to the corresponding data.

To have us fix this problem for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

Fix it for me

To fix this problem automatically, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

Fix this problem
Microsoft Fix it 50915

Notes

This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Then, go to the "Did this fix the problem?" section.

Let me fix it myself

To resolve this issue, follow these steps:

Click Start, click Run, type regedit in the Open box, and then click OK.
Locate and then select the following registry subkey:

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
On the Edit menu, point to New, and then click DWORD (32-bit) value.
Type EnableFullRowSort, and then press Enter.
In the Details pane, right-click EnableFullRowSort, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor.

Did this fix the problem?

Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support
(http://support.microsoft.com/contactus)
.
We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me
(http://blogs.technet.com/fixit4me/)
" blog or send us an email
(mailto:fixit4me@microsoft.com?Subject=KB)
message.

Back to the top | Give Feedback