Excel 2007 - Error Cannot complete task with available resources
Posted on 2013-06-20
Got a support call from an associate who is receiving the message "Excel cannot complete this task with available resources. Choose less data or close other applications" when trying to Insert Columns.
I am familiar with this issue from previous versions and have tried the following things to correct it, but to no avail. If you have any other suggestions it would be greatly appreciated:
Here's what we've tried:
1. Closed all other open applications and re-opened the Excel File.
Pressed Ctrl-End to see where the active area ends. It ends in MC (2 rows from the bottom of the worksheet). Tried deleting columns from MC through the end of the worksheet. Got same error message
2. Tried clearing All formats/data for the cells to the right of column MC - same issue
3. Tried re-saving the file under a different name. Reopened the file and tried again with no success.
3. Went to the Visual Basic Editor for the active sheet ant in the Immediate Windows typed ActiveSheet.UsedRange to try to reset the Active area. When we pressed ENTER in the VBE window we got the "Microsoft Excel has Encountered an Error" message and the worksheet closed.
So - I'm stumped. Any ideas experts?