As I get older around my birthday, I feel like I should have some knowledge to show for it– and of course, to share. The problem is as you get older, you feel stupider and less creative. Another one of life’s cruelties: when you want it you can’t have it and when you have it [...]
Excel cannot complete this task with available resources (Excel Error Solution)
Posted By admin on May 16th, 2012
I routinely do fairly complex things with files with over a hundred thousand rows with formulas. I thought i’d finally broken Excel when I got this error while working with such a file:
Excel cannot complete this task with available resources.
The truth is, Excel can complete the task with the resources, you just need to remove an update that Microsoft sent you with the intent of blocking some malicious code. This update is Titled: security update for Microsoft Excel 2010 (KB2597).
To fix this problem, navigate to Installed Updates which lives in this folder: Control Panel\Programs\Programs and Features
Search for KB2597166 as you see in the photo below, right click and remove/uninstall and back to your Excel work, nerd.
this is the bastard right here
Tags: excel, KB2597, microsoft
Similar Posts
Share
June 15th, 2012 at 5:42 am
Hello
I have the same error, i searched for the file you mentioned, but i cannot locate it. the closest i found was KB2597091. could this be the problem file?
July 11th, 2012 at 5:32 pm
Thanks for posting this fix, it fixed the problem for us.
September 11th, 2012 at 10:38 am
Thanks for this wonderful discovery
September 12th, 2012 at 12:22 am
No problem fellow excel geeks
October 28th, 2012 at 6:15 pm
What about Megan’s question? What if KB2597166 does not exist or, in my case, it did exist, I torched it, but the Excel error message comes back nonetheless?