|
Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week |
|
|
|
How to remove COM Add-ins COM add-ins are compiled add-ins. They are created outside of Excel by special programs and designed to work within Excel. Unfortunately Excel frequently runs into memory problems if one has COM add-ins installed. They can cause regular add-ins not to work correctly, as Excel runs out of memory. We have even seen a case where Excel's own calculation functions return errors and formulas in Excel return errors. All of our add-ins are VBA add-ins. VBA add-ins are designed to work within Excel, are not compile and thus taking away memory from excel, and do not cause memory problems with Excel. Whenever we can, we don't install the VBA full add-in on startup. Just a tiny VBA add-in that calls the main add-in as needed. This makes Excel load faster. We strongly recommend you do not install any COM add-ins. Unfortunately, they sneak into Excel without permission. And, some Excel add-in makers release their products as COM add-ins. Check before you buy...... The number one COM add-ins that sneaks in is an Adobe COM add-in. We also see frequently see a BlueTooth COM add-in and a Snag-It COM add-in sneak in. It is best to check after each software install to see if any COM add-ins got secretly put into Excel. The number one thing you can do: If you have any COM add-ins installed, un-install them unless they are absolutely required. To un-install COM add-ins:
February 5, 2010 update: We have found that the above will not remove all COM add-ins. Some avoid the Microsoft Excel COM add-in dialog and must be removed manually. To do so, you will need to edit the registry. In the RUN box type "RegEdit" and click OK. Then navigate to the following registry keys:
With Excel closed, click on each entry expands it to show its various settings or keys. Click on the "LoadBehavior" of each. Change the setting to zero (0). We have noticed that it sometimes takes multiple changing of the keys to zero until the setting holds. Somehow these programs reset the key. An alternative is to click on the entry on the left side of the registry and delete it and all its keys. Be sure to backup the registry before deleting any entry.
|
Order online. Order Risk Free
|
| Copyright 2011 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
