Microsoft Excel Memory Issues - Cannot complete this task with available resources
Posted on 2012-09-06
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.
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?