FIx Excel Not Enough Memory error
First make sure you have the “compatibility view” setting on

when in the internet options of IE 10…go to the “advanced” tab.

Scroll down to and uncheck these 3 options:

Enable Enhanced Protected Mode*

Enable Integrated Windows Authentication*

Enable Native XMLHTTP Support

Enable Smartscreen filter

Enable Strict P3P Validation*

On top of disabling these options…you will have to go into the security tab and disable the protected mode for all of the 4 zones.

If all this does not work. I also lowered the bars on 3 of the 4 zones to the lowest levels (the restricted sites zone does not let you do this)