Microsoft Excel Memory Issues - Cannot complete this task with available resources

I am running Windows 7 Enterprise 64-bit with MS Office 2010 32-bit, fully patched.

I have an analytics user with an Excel file that contains a single table which is 22,000 rows x 617 columns.  No vlookups or other formulas - just data (text and numbers).  No pivot tables or charts.  The file is ~25MB in size.

The user is attempting what seems like simple tasks - delete a column, add a column, delete filtered rows, etc.  In all cases, Excel refuses with "Excel cannot complete this task with available resources.  Choose less data or close other applications.

The hardware is robust - 8GB RAM and Core i7 processor.

Task manager is showing only 31% of physical memory in use, and only ~250MB allocated to EXCEL.EXE *32 process.

My questions:
1) why is Excel not accessing more of the roughly 5GB of available physical memory in order to complete these tasks?
2) if Excel 32-bit is limited to only addressing 2GB, why does it not expand to at least this size to accommodate this request?
3) likewise, if Excel is currently utilizing 250MB of memory, why is an operation on a 25MB file causing it to max out resources?
4) finally, what can be done?

Thank you!
Who is Participating?
Pgh_HabitatConnect With a Mentor Author Commented:
I upgraded to Office 2007 x64 (including Excel), and this resolved my issues.  Excel is now accessing 1.5 GB of RAM when necessary to handle these operations.
Try not to add / remove full columns / rows.

In 2007+ there are far far more rows to shift about and this can cause problems.
Try using [ctrl]+[shift]+[left/right/up/down arrows] to select rows of data and insert / delete rows / columns of data only, not full rows/columns.
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.