logo ASAP Utilities

Answered Questions (FAQ)

If you have a question or experience a problem with ASAP Utilities then please verify if there is already an answer to your question or solution for you problem in our list of frequently answered questions.

Upgrading

How to upgrade to the latest version of ASAP Utilities.

What to do if I don't see ASAP Utilities in the Excel menu?

Date: June 28, 2005 (last updated on Januari 25, 2021)
reference id: QA0044

Questions

If you have one of the following questions then we have a quick solution for you on this page.

  1. ASAP Utilities doesn't show up in the menu after the installation.
  2. You've just upgraded you Excel version (for example from Excel 2013 to 2016) and now you don't see ASAP Utilities anymore in the menu of the new Excel version.
  3. Suddenly ASAP Utilities has disappeared from Excel. You don't see it in the menu (or ribbon) anymore.

If you get an error from ASAP Utilities during the startup of Excel then you might want to verify if a part of ASAP Utilities is disabled by Excel.

Solution 1

Option A:
If you've chosen to create start menu shortcuts during the installation then you can choose:
Windows Start > All Programs (or All apps) > ASAP Utilities  > Add ASAP Utilities to the Excel menu
In ASAP Utilities Version 4 and 5 this will open Excel with a special workbook and you only have to click on the Next button then to automatically add ASAP Utilities to the Excel menu.
In ASAP Utilities 7 this will run a program that adds ASAP Utilities to the Excel menu.

Option B:
As an alternative, you can also run the following program which only adds ASAP Utilities to the Excel menu for the user that runs it. Starting from ASAP Utilities version 7, this file is located in your ASAP Utilities program files folder.
Add_ASAP_Utilities_to_the_Excel_menu.exe (557 KB)

Option C:
If you've used ASAP Utilities before, then please verify that ASAP Utilities is not disabled by Excel.
In case ASAP Utilities is disabled by Excel, then follow these steps:
1. In Excel, click File, click Options, and then click Add-Ins.
2. In the Manage list, click Disabled Items, and then click Go.
3. In the Disabled Items dialog box, select the ASAP Utilities file and then click Enable.
4. Restart Excel.

Solution 2

Re-run the setup.
If you reinstall ASAP Utilities it should be visible in the menu again. If you don't see it, please try solution 1.

Solution 3

You can let Excel know (again) that you want ASAP Utilities to be loaded every time you start Excel. This can be done with a few simple steps:
For Excel 2003/2002/2000:
add-to-excel-menu.php#menu
For Excel 2016/2013/2010/2007:
add-to-excel-menu.php#ribbon

If this doesn't work then please check solution 4.

Solution 4

If you use Excel 2007/2010/2013/2016/2019/365 or later then there is an option to disable all add-ins.
Please make sure that option is not checked:

  1. Select the Office button in Excel (left-top) or choose File
  2. Choose "Excel Options"
  3. Choose "Trust Center"
  4. Click on the "Trust center settings" button
  5. Then in the left choose "Add-ins"
  6. Make sure the option "Disable all Application Add-ins (may impair functionality)" is not set because it will disable ASAP Utilities too.
    If that option is checked then please uncheck it and restart Excel.
    The setting 'Disable all application add-ins' disables ASAP Utilities too

Solution 5; When Excel is started programmatically add-ins are not loaded

Add-ins are not loaded when Excel is started programmatically.
In combination with Windows Explorer we've seen that once before where a user had installed some sort of plug-in/program that added functionality to Windows Explorer, that caused Excel to start programmatically when the user double-clicked on an Excel file in Windows Explorer.
Add-ins are not loaded when Excel is started programmatically.
A workaround to load ASAP Utilities if Excel is started like that, can be to turn it off and on in the add-in manager.
Or perhaps you can click on the "ASAP Utilities" button in the start-menu.

References:
https://support2.microsoft.com/default.aspx?kbid=213489
http://www.mrexcel.com/forum/excel-questions/796344-add-ins-not-loaded-when-opening-excel-programmatically.html
http://stackoverflow.com/questions/25114702/add-ins-not-loading-when-opening-excel-file-programmatically
http://stackoverflow.com/questions/213375/loading-addins-when-excel-is-instantiated-programmatically

In addition, we also found the following where an (invisible) instance of Excel caused this.
In that case restarting your computer should fix it.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/when-opening-a-file-directly-add-ins-do-not-load/5ae0f92f-8c9c-4860-974d-4ae97ed99763

A repair of the office installation might also correct it. That is also what worked for someone with a similar issue as discussed in the following topic:
http://www.mrexcel.com/forum/excel-questions/707444-excel-add-not-loading-when-opening-file.html

Solution 6; Group Policy on Windows server

There is a Group Policy object (GPO) in Excel 2007 and later, called "Disable UI extending from documents and templates".
This policy setting controls whether Office (2007+) applications (such as ASAP Utilities) load any custom user interface (UI) code included with a document or template.

  • If you enable this policy setting, Office applications cannot load any UI customization code included with documents and templates.
    That also means that you don't see the ASAP Utilities tab in the Excel ribbon.
  • If you disable or do not configure this policy setting, Office applications load any UI customization code included with a document or template when you open it.
    This is the standard setting from Microsoft and the recommended setting if you want to use ASAP Utilities.


You can find it via:
User Configuration > Administrative Templates > Microsoft Office > Global Options > Customize >
set "Disable UI extending from documents and templates" to "Enabled"
set "Disallow in Excel" change to "Disabled".


References:
https://msdn.microsoft.com/(...)DeployCustomRibbon_UsingAdministrativePoliciesRestrictUICustomizations
https://social.msdn.microsoft.com/(...)-changes-to-other-ms-office-2010


Additional keywords:
menu bar, not showing, missing, disappeared, disappears, disappearing, add in not displaying on menu, not visible, Excel, Office, how do i get asap to show up on my menu bar, menu item ASAP Utilities missing after installing, installed asap but not on menu bar, dropdown, drop down, toolbar, How to add ASAP Utilities to Excel menu?, add-ins enabled, but will not display, open, cannot see, can't find, adding to




« back


Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
© 1999-2021 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook