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)
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.