home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week


Money back

What to do if add-in tabs or buttons do not appear

After an install, new tabs should automatically appear in Excel. Depending on your purchase you will see one or all of the following tabs in Excel: Assistants, Charts, Data Add-ins, Time Savers and Specialty. If you installed the Business Analysis Collection or the Risk Analysis Collection then you would see tabs named Business or Risk.

Sometimes the tabs and tool bars do not appear after an installation or the tabs or tool bars have disappeared after many months or years of use.  Sometimes, a crash of Excel causes. Sometimes Microsoft updates, IS updates, or third party installs (or de-installs) may cause the disappearance.  All are easy to solve.

To make the tabs appear
  • Open Excel and do the following:
  • Click the green File ribbon tab, Options, Add-ins. 
    • Then, in the right side panel click the GO button beside "Manage Excel Add-ins"
  • If you see Add-in Mgr 2007-2013 checked
    • uncheck it
    • close the dialog by the OK button
    • close Excel (must do!)
    • Then repeat the above steps to display the dialog and then do the following
  • All:  A small dialog titled "Add-ins" will appear. Click the BROWSE button on this box
    • Go up to the Roaming folder by clicking on in the folder path box and remove "Microsoft\add-ins" and pressing Enter
    • Select the Folder named "Add-ins" under the Roaming folder*
    • Select ONLY the file named "Add-in Mgr 2007-2013.xlam"*
    • Click OKs to finish the install. If told you are replacing an existing entry, agree to the replacement.
*IF you do not see the "Add-Ins folder (not the default addins folder) or Add-in Mgr 2007-2013.xlam, this means you are not running the install EXE as Admin or for some reason (paranoid IS Dept?) installs to the normal install folder are blocked.  To solve, do the following:
    • In your Documents folder, create a folder called My Software
    • Close Excel and re-run the install and specify this folder instead. It will create a sub folder named "Add-ins"
    • Open Excel and if the Add-ins tabs do not appear, do File, Options, Add-ins, GO
    • In the small dialog that appears, click on the Browse button
    • Navigate to My Documents\My Software\Add-ins and select just Add-in Mgr 2007-2013.xlam
      • Click OKs to finish the install. If told you are replacing an existing entry, agree to the replacement

Copyright 2024 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.