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
This is an old article that has been archived.

Method 'Add' of object 'CommandbarControls' failed

Published: September 19, 2005 (latest revision May 15, 2017)
reference id: QA0056
This is an old article that has been archived.


First make sure you're using the latest version of ASAP Utilities.

If you get the error message upon install it might help to just click away the error, close excel, restart en then add ASAP Utilities as add-in:

  1. Run Microsoft Excel
  2. On the tools menu, choose Add-Ins.
  3. Use the "Browse..." button to locate the ASAP Utilities.xla file (default is C:\Program Files\ASAP Utilities)
  4. If Excel asks you to copy the file to the library folder, answer "no".
  5. Check the "ASAP Utilities" check box.
  6. Next to "Help" in the menu, there is an option called "ASAP Utilities".

If the above solutions doesn't work,. the problem often is a corrupt or bloated toolbar file. A *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

You can try the following:

  • Close Excel Do a search for .xlb in windows
  • Rename the file you find, e.g. rename the .xlb to .bac (my file is named Excel10.xlb in 2002, Excel11.xlb in 2003)
    If you make your own toolbars or add buttons to the others this file is important (backup it so you can restore it)
    Deleting the file or renaming will do no harm on your system, Excel will automatically create a new one for you. (However you lost your customization remember that) 
  • Start Excel 


(source: Ron de Bruin)





« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years