Tuesday Tip: How to Fix: ‘Excel cannot complete this task with available resources. Choose less data or close other applications’

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!

Network 1 Consulting is a 14-year-old, IT Support company in Atlanta, GA.  We become – or augment – the IT department for professional services companies: law firms, medical practices and financial services firms.  Our IT experts can fix computers – but what our clients really value is the industry-specific best practices we bring to their firm.  This is especially important with technology, along with regulations and cyber threats, changing so rapidly.  We take a proactive approach to helping our clients use technology to gain and keep their competitive advantage.

This entry was posted in application, business-class computers, IT Management, IT Professionals, IT Support, Network 1 Consulting, Technology, tips. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s