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.

Method 'Add' of object 'CommandbarControls' failed

Date: September 19, 2005 (last updated on July 31, 2009)
reference id: QA0056


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

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - 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