0 votes
ago in Other by Beginner (11 points)
I've had a problem since I moved to Excel 2016, my Wells Pro add-in doesn't appear.  It shows in my Excel Add-ins, but there's no ribbon tab, it doesn't show in my VBA projects, I have no way to get to any of the functionality.  Today I got an Update email from Ryan, downloaded the update and ran through the entire installation.  No problems, just no difference.  Nada, zip.  The add-in might as well not exist.
ago by Beginner (0 points)

Just Asking to confirm:

The Update wllsPRO.04 is the same version 1.1.3?  (but with new Patch?)

I had the release 1.1.3  I downloaded the wellsPRO.04 and installed it.

I check the Update option and it said that I have Release 1.1.3

That is correct?,

ago by Super Expert (3.2k points)
Yep, I kept version at 1.1.3 since it's functionally the same as the other version, just with that bit of dead code commented out. I had to keep the versions the same to prevent some download issues for a few users running a "no update" version of the code.

1 Answer

0 votes
ago by Super Expert (3.2k points)

Dang it! Thanks for letting me know. Let's try these steps:

  1. Open Excel and go to File > Options
  2. Click Add-ins on the left bar
  3. See where the wellsrPRO add-in is saved. The screen should look like this:
  4. Close Excel, then go to that folder and DELETE the wellsPRO add-in.
  5. Re-open Excel
  6. The add-in should (hopefully) be removed from the list
  7. Try installing the wellsrPRO add-in again from scratch using the installation instructions.
I'm really sorry about all this, jomili.
ago by Beginner (11 points)
Well, we made SOME progress.  In my VBA editor I can now see the WellsPro project.  But still no ribbon tab, no way to get in to use the add-in, and no warning messages that anything is amiss.
ago by Super Expert (3.2k points)
Under the File > Options > Add-ins screen, is the add-in listed as "active" or "inactive?" It might be better to rename the file something else so Excel recognizes it as a new add-in and isn't corrupted by the old version that's not working.

Before doing that, go to File > Options > Trust Center > Trust Center Settings. Under Add-ins, make sure all the boxes are unchecked. Then, under Macro Settings, make "Disable all macros without notification" is not enabled. After that, go to Trusted Locations and add a new location pointing to wherever you have the wellsrPRO add-in saved.

Restart Excel after following those steps and see if it works.  If it doesn't work, you can save the add-in in one of the XLSTART folders in the Trusted Locations section described above. That will trigger it to open each time Excel starts. This solution should work. Fingers crossed! Keep me posted!
ago by Beginner (11 points)
Okay, It IS showing as "Active", and it IS showing in my VBA Projects.  I tried it in my XLSTART earlier today and it showed in my VBA Projects.  However, nothing I do gets the Tab to show up.

On "Trusted Locations", looks like IT has turned that off.  I can't add a "Trusted Location", but if you think that will help I can contact my IT guy.  Please advise.
ago by Super Expert (3.2k points)

If you've tried placing it in one of the XLSTART folders, that ought to have the same effect as adding a new Trusted Location, so I wouldn't worry about getting IT involved for that issue.

What I might get IT to check, though, is that they don't have a Group Policy Setting that is preventing add-ins from being loaded properly. Here's an article that describes the group policy setting that can cause this issue. 

Excel Campus also has a guide and video with more ways to fix a ribbon disappearing on launch. I think we've tried most of those tactics, but it might be worth looking at again to see if there's a nuance somewhere that we missed. I have a feeling it's a Group Policy Setting, though.

Welcome to wellsr Q&A
wellsr Q&A is the VBA and Python programming community that rewards you for learning how to code.

Getting Started
VBA Cheat Sheets (On Sale Now)

Earn free prizes for asking VBA and Python questions and for answering questions asked by others in our community.

Looking for something else? Hire our professional VBA Help, instead.

What makes us different?
Our points system rewards you with a chance for free gifts based on the quality of your questions and answers. All you have to do is post and you could get rewarded, like these members:

ParserMonster $25 Amazon Gift Card
Hightree $10 Amazon Gift Card
Thales1 $10 Amazon Gift Card
runfunke $10 Amazon Gift Card
coolag $10 Amazon Gift Card
Siew Hun $10 Amazon Gift Card

So, why don't you join us? It really is an encouraging way to motivate members in our VBA and Python community.


For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.