- In Excel, go to File -> Options -> Add-ins
- If Enabler4Excel add-in shows up under the Inactive Add-ins list:
– Select COM Add-ins from the drop-down and click Go
– Remove the checkmark against Enabler add-on
– Click OK
– Click Go again
– Now set the checkmark against XL-Connector add-on
– click OK
- If XL-Connector add-in shows up under Disabled Items list:
– Select Disabled Items from the drop-down and click Go
– Select XL-Connector
– Click Enable
Your Enabler tab should be back in the ribbon.
Now if the steps above helped, but you have to do it every time you start Excel, here’s how to solve this:
- Press Windows+R and type ‘regedit’, then click OK.
- In the registry editor, find the following key:
For 64-bit Excel installations:
For 32-bit Excel installation:
- Make sure that the LoadBehavior value is set to 3.
If none of the steps above helped, you may have add-ins disabled entirely in your security settings. To change that:
- Go to File -> Options in Excel.
- Click on Trust Center -> Trust Center Settings
- Click on Add-ins on the left.
- Check if ‘Disable all Application Add-ins’ box is not checked:
It would help a lot if you could remember what function you were using prior to when that happened, and shoot us a quick e-mail at email@example.com