MarketXLS

Restore a missing MarketXLS ribbon

Excel can disable a COM add-in after an update, a slow startup, or an unexpected shutdown. Check the normal add-in list first, and then check disabled items.

Check COM add-ins

  1. In Excel, select File > Options > Add-ins.
  2. At the bottom of the window, select COM Add-ins from Manage.
  3. Select Go.
  4. Select the checkbox for MarketXLS.
  5. Select OK.
  6. Close Excel, and then open it again.

If the MarketXLS tab returns, enter a test formula before you reopen a large workbook.

Check disabled items

  1. In Excel, select File > Options > Add-ins.
  2. At the bottom of the window, select Disabled Items from Manage.
  3. Select Go.
  4. If MarketXLS appears, select it and then select Enable.
  5. Close Excel, and then open it again.

Reinstall the add-in

If MarketXLS doesn't appear in either list:

  1. Close Excel.
  2. Uninstall MarketXLS from Windows Installed apps or Programs and Features.
  3. Restart Windows.
  4. Install the current Windows add-in.

Avoid weakening Excel Trust Center settings as a general fix. If an organization manages your Office security policy, ask its IT administrator to review the add-in instead.