BACK TO PCSTATS Follow PCSTATS on Facebook PCSTATS RSS Feed PCSTATS Twitter Feed + Motherboards
+ Videocards
+ Memory
+ Beginners Guides
News & Advanced Search  Feedback?
[X]   Directory of
Guides & Reviews
The PCstats Forums

Beginners Guides
Weekly Newsletter
Archived Newsletters


Beginners Guides: Hard Drive Data Recovery

PCSTATS TechTip: Excel Cannot Complete this Task with Available  Resources - SOLVED - PCSTATS.com PCSTATS TechTip: Excel Cannot Complete this Task with Available Resources - SOLVED
Mon, Oct 27 2014 | 2:58PM | Filed under: Tips| PermaLink Posted by: STAFF

PCSTATS TechTip: SOLVED - Excel Cannot Complete this Task with Available Resources...

So, you have a massive 45MB Excel spreadsheet open with multiple pages and you're about to update a few thousand cells when this error box pops up: "Excel cannot continue this task with available resources. Choose less data or close other applications. Continue without Undo?" What to do?! This can be a frustrating experience, especially if you're certain the computer is powerful enough and has 4GB or more RAM installed. The issue is indeed resources related, but adding more memory will not fix things. If for example you have Chrome or Firefox open with a couple dozen tabs at the same time, closing that browser while working in Excel can help alleviate the resource limitation... but not always.

www.pcstats.com

A PCSTATS reader who uses Microsoft Office Home and Business 2013 recently wrote in for help with this problem . Here's the permanent way to solve the "Excel Cannot Complete Task with Available Resources" error.

How to Fix: Excel Cannot Complete Task with Available Resources Error

To begin with, confirm you are running the 64-bit version of Microsoft Windows 7 or 8 operating system. Next launch Excel, then open up 'Task Manager' (right click on taskbar > Start Task manager) and navigate to the 'Processes' tab. You should see "Excel.exe *32" listed. If that's the case, the reason Excel is crapping out when you work with large .xlsx spreadsheets is because 32-bit Excel is installed and 32-bit Excel can only address 2GB of system RAM. Excel needs more system resources, but for that you MUST install the 64-bit version of Microsoft Office.

To do that, uninstall Office 2013 and reinstall the 64-bit version of Office 2013. This is easily done from the 'Office Home and Business 2013' disk by 1) CANCELLING the setup.exe program which immediately loads and then 2) navigating on the Office disk to the folder '/office' and double clicking on 'setup64.exe'. This will force Office 2013 to install the 64-bit version -- the default installer loads the x32 version of Office which is compatible with both x32 and x64 operating systems.

That's it! With the 64-bit version of Microsoft Office Home and Business 2013 installed Excel will address as much memory as is installed & available to applications. This PCSTATS TechTip can be applied to Office 2010 which also comes in x32/x64 flavours. If you want to confirm you've installed the x64 version of Office 2013, launch Excel, then open up 'Task Manager' (right click on taskbar > Start Task manager) and navigate to the 'Processes' tab. You will now see "Excel.exe" listed, which means a native x64 application is running in the x64 version of Windows 7/8 operating system.

For good measure, you can also take the extra step of installing 64-bit version of Chrome Beta.

FULL STORY @ PCSTATS

Recent News in Tips
Office 2013 Crashes on Start Up - Solved - PCSTATS TechTip Feb 26
PCSTATS TechTip: Excel Cannot Complete this Task with Available Resources - SOLVED Oct 27
PCSTATS TechTip - Automatically Shut Down Windows at a Certain Time Jan 27
PCSTATS TechTip - More to Calculator than you think Jan 13
PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files Jan 6
AMD fans rejoice Oct 10
TIP - Windows 8 and Bringing back the Start Menu May 2
TechTip - Bring Back the Quick Launch Bar in Windows 7 May 2
Windows 8: How to Bypass Metro and Boot Directly to the Desktop Interface Oct 31
HotHardware's 2012 Back To School Shopping Guide Aug 28
more...

News Categories
Audio / Sound Beginners Guides Benchmarks
Biometrics BIOS Business / Industry
Cases Chipset Computer / SFF PCs
Cooling / Heatsinks CPU / Processors Digital Cameras
Drivers Editorial Games
Gossip Hard Drives/SSD Hardware
Home Theatre Imaging Memory
Mobile Devices Monitors Motherboards
Mouse Pads MP3 Players Networking
Notebooks Operating System Optical Drives
Overclocking Peripherals Power Supply
Press Release Printers Servers
Site News Software Tips
Tradeshows / Events Video Cards Web News
   Looking for something a little farther back? Try PCstats News Archives: 1999 - present
   11 / 17 / 2019 | 7:52PM
Hardware Sections 


google
 
PCSTATS Network Features Information About Us Contact
FrostyTech
PCSTATS Newsletter
ShoppingList Assistance
Tech Glossary
Technology WebSite Listings
PermaLink News
Archived News
Submit News (Review RSS Feed)
Site Map
PCstats Wallpaper
About Us
Employment
Privacy Policy
Advertise on PCSTATS

How's Our Driving?
© Copyright 1999-2019 www.pcstats.com All rights reserved. Privacy policy and Terms of Use.