Please leave a comment below with any questions.
Checkout my video on how to re-enable an add-in that is missing for more info. If you still don't see the Add-in, it might be disabled. I hope that helps get your add-in Ribbon back. Here is an article that explains how to change the Group Policy setting. Sometimes they don't even know this setting has been applied, so go easy on them. This is something that will be controlled or set by your IT department. If you've tried all the steps above and still don't see the XL Campus tab appear then it could be group level policy setting for Office. Custom UI Ribbon Blocking – Office Group Policy Therefore it is probably best to add the add-in file to the Trusted Locations list in Excel.
However, if you download an updated version of the file then you will have to repeat the steps above to unblock it. You will only need to do this unblock one time. The add-in should now load and any custom ribbons will appear.
This is an additional property that was added with the Office Security Update for all files downloaded from the internet.
If this is the case you will also need to Unblock the file. Some users have reported that adding the folder to the Trusted Loactions list still does not solve the problem. Additional Solution: Unblock the Add-in File For most users, it is not trusted by default. If you store add-ins in this default AddIns folder then you will need to add it to the Trusted Locations list.
This makes it easier to find the files and keep them organized. I like to store my add-ins in a folder within my Documents folder. Add the Add-in File's Folder as a Trusted Location
You can either move the add-in file to a trusted location, or add the add-in file's location to the list of trusted locations. A Trusted Location is a folder on your hard drive or server that has been added to the Trusted Locations list in Excel. The best solution to this problem is to store the add-in file in a Trusted Location. ? Video: How to Fix the Disappearing Add-in Ribbonīest Solution: Store the Add-in in a Trusted Location The following video explains how to prevent this from happening, so we can turn that frown upside down and get on with being productive. So if you have downloaded an Excel Campus add-in recently, or an add-in from another site, then you might not be seeing the custom Ribbon menu after open Excel. That means there is nothing to tell you why the add-in Ribbon disappeared. However, there is no security prompt for add-in files (.xla. xlsm), you will get a security prompt asking you if the file is safe. When you open regular Excel files (.xlsx or. The security update is blocking files that have been downloaded from the internet.įiles downloaded from the internet now have a Security property that is automatically set to Block. Microsoft released an Office Update in July 2016 that is causing this issue with installed add-in Ribbons disappearing. Why Did My Add-in's Ribbon Menu Disappear? This article contains a few solutions for this issue. Bottom line: A recent Microsoft Office security update has caused add-in Ribbon Menu Bars to disappear when Excel is opened.