Excel cannot complete this task with available resources…

Excel cannot complete this task with available resources. Choose less data or close other applications – this is quite annoying one as its totally intermittent and hard to replicate. I’m posting solution for it here in case someone is experiencing an issue and cannot find anywhere online the way to resolve it … and of ...