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.

Priority support for clients

If you can't find the answer on our website then please contact us.

Version history

A history of the various updates and improvements throughout the years

How it makes YOU rock in Excel

These short tutorials show you how to benefit from the tools in ASAP Utilities and are guaranteed to save you time and speed up your work in Excel.

User Guide

The ASAP Utilities User Guide is a practical manual that will show you how to get the best out of our excel add-in

Uninstall

How to (temporary) uninstall ASAP Utilities.

Bug report

If you have found a bug first make sure you are using the most recent version. If that is the case go to our bug-report page

Debug information

In some cases you will be asked by our support-team to turn on the debug-mode to help solve specific problems.

Links

Links to interesting websites

Excel Books

The best books on Excel. Whether you want to learn Excel, write better formula's, learn how to use macros or write professionals applications in Excel these are the best books

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

Published: June 28, 2005 (latest revision November 16, 2023)
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 2016 to Excel 365) 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.

Possible Solutions

Solution 1 - Automatic

The easiest way to fix this, is to run the 'Add_ASAP_Utilities_to_the_Excel_menu.exe' program which only adds ASAP Utilities to the Excel menu for the user that runs it.
This file does NOT require special/administrator rights, so any user can run it.
Windows Start > Add ASAP Utilities to the Excel menu
Or in older Windows versions:
Windows Start » All Programs » ASAP Utilities  » Add ASAP Utilities to the Excel menu


Note: this option is only available if you've chosen to create start menu shortcuts during the installation of ASAP Utilities.
If you don't see this entry in the Windows Start menu, then you can start it by running the 'Add_ASAP_Utilities_to_the_Excel_menu.exe'.

Starting from version 7, this file is located in the ASAP Utilities program files folder (by default C:\Program Files (x86)\ASAP Utilities\).
Add_ASAP_Utilities_to_the_Excel_menu.exe
Of you have an older version of ASAP Utilities, then you can download the file from:
https://server1.asap-utilities.com/support/Add_ASAP_Utilities_to_the_Excel_menu.exe (557 KB)

Solution 2 - In case Excel has disabled ASAP Utilities

If you've used ASAP Utilities before, then please verify that ASAP Utilities is not disabled by Excel.

Sometimes when Excel crashes, it (randomly) disables add-ins or asks you to do so.
In case the file 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 3 - Manually add it to the Add-ins list

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:
1. In the Excel menu choose File > Options > Add-ins
2. In the Manage drop-down at the bottom select Excel Add-ins and press the Go... button.
3. Click on the Browse... button in the Add-Ins dialog to locate the ASAP Utilities.xlam file (by default this is located in the folder "C:\Program Files (x86)\ASAP Utilities").
Should Excel ask you to copy the file to the library folder, answer "no". (this is important).
5. Check the "ASAP Utilities" check box and press the OK-button.

If this doesn't work then please check the other possible solutions.

Solution 4 - When all Application Add-ins are disabled

If you use Excel 2007/2010/2013/2016/2019/2021/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 - Blocked by Group Policy object (GPO), no customizations to the Ribbon allowed

You can verify if this is the case by enabling the Office wide setting "Show add-in user interface errors".
In Excel choose File > Options > Advanced, then scroll down and then check "Show add-in user interface errors".
When you then restart Excel, you will see a message similar to "The custom UI associated with this document has been disabled by policy":
The custom UI associated with this document has been disabled by policy.

To solve this, you need the help from your IT department.

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 Excel) load any custom user interface (UI) code included with a document or template (or add-in such as ASAP Utilities).

  • 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 >
in case "Disable UI extending from documents and templates" is "Enabled"
set "Disallow in Excel" to "Disabled" so that the ASAP Utilities tab can be shown in the Excel Ribbon.

This setting is stored (if set) in the registry in the DWORD value NoExtensibilityCustomizationFromDocument in
for Excel 2016-2021/365:
HKCU\Software\Policies\Microsoft\Office\16.0\common\toolbars\excel
for Excel 2013:
HKCU\Software\Policies\Microsoft\Office\15.0\common\toolbars\excel
for Excel 2010:
HKCU\Software\Policies\Microsoft\Office\14.0\common\toolbars\excel
for Excel 2007:
HKCU\Software\Policies\Microsoft\Office\12.0\common\toolbars\excel

If the value of NoExtensibilityCustomizationFromDocument is 0 then customizations are allowed. If the value is 1, then ASAP Utilities cannot display its menu in Excel.

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 Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years