Bug #74993 Mysql for excel addin missing.

• Submitted: 25 Nov 2014 10:31
• Modified: 5 Dec 2014 15:21
• Reporter: Neelakshi Nehru
• Status: Not a Bug
• Category: MySQL for Windows: MySQL for Excel
• Severity: S2 (Serious)
• Version: 1.3.2
• OS: Windows
• CPU Architecture: Any
• Tags: addin, Excel, MySQL for Excel, plugin

[25 Nov 2014 10:31] Neelakshi Nehru

Description:
The mysql for excel plugin isn't showing up on the toolbar. It was showing up in com addins but not getting selected due to the error “The connected state of Office Add-ins registered in HKEY_LOCAL_MACHINE cannot be changed”. 
I then :
1)Navigated to “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ Outlook\Addins”.
2)Enabled the particular Add-in, set its “LoadBehavior” key to 1.

After setting the addin option in 'excel options' to com addin I could now check the box for mysql for excel and the status was showing as loaded. However the plugin still didnt come up in the toolbar and upon further opening Excel option->Addins ,i noticed that the addin option had automatically changed to excel addin. Solution required !

How to repeat:
Dodn't know how to do that.

[25 Nov 2014 15:03] MySQL Verification Team

Please try version 1.3.3: http://dev.mysql.com/downloads/windows/excel/. Thanks.

[25 Nov 2014 18:04] Neelakshi Nehru

Same result :/

[26 Nov 2014 7:04] MySQL Verification Team

Bug #75005 marked as duplicate of this

[26 Nov 2014 8:48] Neelakshi Nehru

The solution please ?

[28 Nov 2014 16:47] MySQL Verification Team

Which version of Excel are you using?.

[1 Dec 2014 3:35] Neelakshi Nehru

Excel 2007(12.0.4518.1014)

[4 Dec 2014 16:25] Javier Treviño

Do you have other add-ins installed??

If so first try to disable all other add-ins just to rule out the possibility that another add-in is conflicting with MySQL for Excel.

Also please look at what I suggested in the forum post below. Specifically to the part to show any exceptions thrown by Excel when attempting to load add-ins:
http://forums.mysql.com/read.php?172,603610,604759#msg-604759

[4 Dec 2014 17:03] Neelakshi Nehru

No other COM addin was installed initially ! However I later installed the Power Query plugin which is working perfectly, though the Excel plugin is still not working. Regarding the link you've mentioned I'd already visited the blog mentioned there but to no avail. All my settings are in accordance to what has been mentioned in the blog.

[4 Dec 2014 17:32] Javier Treviño

Can you elaborate on the results of enabling the exceptions when the add-ins are loaded? You just said "with no avail". Did you test this? If MySQL for Excel is not loading there should be an exception being thrown by Excel.

In order to help you with this we need to know exactly how to replicate your specific scenario.

[5 Dec 2014 5:03] Neelakshi Nehru

I just installed the trial version of Office 2013 and thankfully the MySQL for excel plugin is working in that ! Thankyou for your concern !

[5 Dec 2014 15:20] Javier Treviño

The problem you are seeing may (most probably) be caused by a reported issue with Office 2007 and COM Add-Ins, a Hotfix from Microsoft is needed, that hotfix is installed also by Windows Update so if you are seeing the issue it means your computer does not have all updates from Microsoft applied.

After the updates are installed or the hotfix is applied the Add-In works fine.

Here is the Microsoft article that explains what I mentioned above:
http://support.microsoft.com/kb/976811/en-us