by Richard Stokes
I like to work in multiple spreadsheets and it’s not uncommon for me to have at least 2 instances of Excel 2010 open on my desktop. In some cases I might actually have a couple of spreadsheets open within each instance. If you want to learn how to quickly open multiple spreadsheets so you can view them side by side, check out my previous blog about ‘opening programs faster’ for that shortcut.
What has been happening is that when I go to open another spreadsheet I often get an error message that says: “Excel cannot complete this task with available resources. Choose less data or close other applications.” To give you some perspective I am running a 2 year old business class workstation with Windows 7 Pro 32 bit, 4GB Ram and a Dual Core processor. I share this to illustrate that ‘memory’ and ‘resources’ are definitely not the issue.
Now since our clients get all the attention from the Network 1 engineers, my fix to the issue has been to close all the spreadsheets and then reopen them to find that the issue miraculously disappears. This is commonly known as a ‘work-around’ and once you’ve got a few of these going it takes time out of your day. So last week, I’d finally had enough and I asked Shane (Network 1 engineer) to see if he could help. Within 20 minutes he shared with me that this error appears to be tied to the Details Pane and Preview Pane feature in Windows 7.
After we turned it off, the problem has yet to rear its ugly head again!
So, if you are getting this error and want it fixed here’s what you do:
1) Open the Excel spreadsheet application
2) Click ‘File’ and ‘Open’
3) Click ‘Organize’ and ‘Layout’
4) Uncheck the ‘Details Pane’ and the ‘Preview Pane’ – To show the difference between the two, in the above screen shot I have unchecked the Preview Pane but not the Details Pane. You will want to uncheck both.
That’s it – now get back to crunching numbers!