The Add-Ins Manager
|Top Previous Next|
Operis hopes that OAK will not interfere with any other Excel add in that you may have installed on your computer. If it does, Operis would like to hear about it.
If a conflict does arise, you may wish to disable OAK temporarily when you are using the conflicting add-in.
The way add-ins are managed has changed in Excel 2007. Earlier versions of Excel had a manager for XLA, XLL and automation add-ins, and a manager for COM add-ins that was separate and harder to find. Excel 2007 and later offer a single add-in manager that lists installed add-ins of all types in one place. While the manager itself is very similar between Excel 2007 and Excel 2013-2019, getting to it is different in each.
Go to Office Button | Excel Options | Add-Ins
For the purposes of accessing the add-ins manager, the user interface is much the same from there, for Excel 2007 to 2019. Just click the Add-Ins item on the left.
In order to enable or disable OAK, locate the drop-down list near the bottom of the Excel Options window, and select "COM Add-ins", then click the "Go" button.
OAK can be disabled using this dialog, and re-enabled again later when you have finished working with any conflicting product.
Enabling the DEVELOPER TAB in EXCEL 2010-2019
If you are using Excel 2010-2019, and you have a need to frequently disable and enable the various COM add-ins (or other add-ins) you use,you may find it helpful to enable the developer tab. This tab contains short cuts to both of Excel's add-in managers. To enable the developer tab, go to the Excel options screen as for the Add-ins manager, but instead of clicking Add-Ins, click Customize Ribbon. Locate "Developer" in the checklist box on the right and click it to enable the developer tab.
Click OK to return to the workspace.
If you need to switch OAK, or any other COM add-in on or off, you can now do this by clicking the Developer tab, then the COM Add-Ins button, rather than the journey through the options.