How To Prevent The Excel Error Message For A Missing Add-in

How To Prevent The Excel Error Message For A Missing Add-in

I’ve run into this issue numerous times and I just figured out how to prevent the dreaded error message from popping up when Excel opens stating:

Sorry, we couldn’t find add-in [insert add-in name]. Is it possible it was moved, renamed or deleted?
— Microsoft Excel

How To Prevent This

First you will want to note the file path that Excel thinks the add-in should be located in and the name of the add-in file. Once you know where that folder is located and the name of the add-in, proceed to do the following:

  1. Create a new Excel file

  2. Save the file with the following conditions:

    • Use the Add-in name

    • Use the Excel file extension “.xlam” (if it is an older add-in it might need to be “.xla”)

    • Save to the same folder path

  3. Once you have saved this new faux add-in file, close down Excel

  4. Reopen Excel and hopefully you won’t receive the error message

  5. Go into your Excel Add-ins dialog box and check the add-in and hit Ok

  6. Go back into you Excel Add-ins dialog box and uncheck the add-in and hit OK

  7. Close out of Excel

You should now be able to go and delete the faux Excel add-in file and not see the error message going forward. Yay!!