Article ID: 2761240 - View products that this article applies to.
When you use add-ins in Microsoft Excel 2013, you experience the following issues.
Issue 1When you load an Excel add-in (.xlam) or an Excel 97-2003 add-in (.xla), the command bars of the add-in are not displayed automatically. Instead, you must close all workbooks and then restart Excel to display the command bars.
Issue 2When you unload an Excel add-in (.xlam) or an Excel 97-2003 add-in (.xla) or close an Excel macro-enabled workbook (.xlsm) that contains command bars, the command bars of the add-in or the macro-enabled workbook are not removed from all open workbooks.
These issues occur because of the new Single Document Interface (SDI) in Excel 2013. When you use a legacy CommandBar object to create menu items, the menu items are added to the Add-Ins tab of the ribbon. In Excel 2013, each workbook has its own ribbon. Therefore, when you load or unload add-ins after the ribbon of the workbook is created, the ribbon is not updated.
The following code sample creates menu items by using the CommandBar object:
To work around issue 1, close all open workbooks, and then restart Excel.
To work around issue 2, use one of the following methods:
Article ID: 2761240 - Last Review: November 22, 2012 - Revision: 3.0