- Symptom description:
Excel 2010 32 bit, 1 document - 1 worksheet in document, no other applications open. 21 columns, 787350 rows of data. Data is numbers, letters, and dates - there are no formulas. Select all cells by clicking on box in the upper left corner(next to column A and row 1), click on 'Sort & Filter' and choose any of the 'Sort' Options(Sort Largest to Smallest, Sort Smallest to Largest, or Custom Sort and select column).
Get Error "Excel cannot complete this task with available resources. Choose less data or close other applications"
i5-2520M 4 core processor, 8GB RAM, Win7 64. All patches/updates applied.
- Any recent relevant
None - happens with a clean system
- Any additional information.
Obviously I have work arounds, but shouldn't this work exactly the same as it does in Excel 2007?
Have a look at
This says the problem is fixed in a recent update.
Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/
Thank you, I had previously come across that page, and while it calls out what appears to be the exact problem - applying the referenced Hotfix (http://support.microsoft.com/kb/2598378) did not resolve the issue. It did uninstall the MS12-030, as it was on my list of possible culprits(it was there previous to the hotfix). Additionally, I have tried the registry key edit here: http://support.microsoft.com/kb/2687317 with no luck.