Excel 2007 – not enough resources

I had a siutation where Excel 2007 would like blow up but not completely.  It would never Dr. Watson, it would just indicate ‘out of resources’


And then the screen would look funky like this:


 


It turned out to be caused by Adobe add ins


Here is a summary of the key points of the case for your records.

Action: Customer upgraded to Office 2007.

Result: Users get errors in Excel such as ‘Not Enough System Resources’.

Cause:

1) This may have been from Com Addins.

2) Customer also made changes to the firewall on the machines in question.

Resolution:

1) Com Addins are removed by setting the LoadBehavior of the addin to
Zero (0) in the registry.

They can be loaded at two locations:

a) HKEY_Current_User\Software\Microsoft\Office\Excel\Addins\<Addin
Name>\LoadBehavior

b) HKEY_Local_Machine\Software\Microsoft\Office\Excel\Addins\<Addin
Name>\LoadBehavior

One Thought on “Excel 2007 – not enough resources

  1. Susan, whenever there’s issues with Office (whether 2007, 2003, or else) acting wierd, the Adobe add-in is always the first thing to disable in debugging the issue.

Post Navigation