Bug #78419 Excel shows the MySQL plugin as COM add-in and there is nothing in the data tab.
Submitted: 12 Sep 2015 22:10 Modified: 20 Oct 2015 12:24
Reporter: Ankit kothari Email Updates:
Status: Duplicate Impact on me:
Category:MySQL for Windows: MySQL for Excel Severity:S1 (Critical)
Version:1.3.4 OS:Windows (Professional)
Assigned to: CPU Architecture:Any

[12 Sep 2015 22:10] Ankit kothari
Operating System: Windows 32 bit
I have Complete MySQL workbench installed along with the excel utility. 
The excel utility is seen in the add in as a COM add in, however nothing is reflected in the data tab of excel. What is the alternative?

How to repeat:
Installing the MySQL utility and running Microsoft excel 2007 on windows Professional 32 bit.
[14 Sep 2015 11:49] MySQL Verification Team
Thank you for the bug report. Which exactly OS Windows version are you using?. Thanks.
[14 Sep 2015 11:53] Ankit kothari
Windows professional. That is what you meant to ask right?
[14 Sep 2015 12:18] MySQL Verification Team
I meant Windows 8.1, Windows XP etc. Thanks.
[14 Sep 2015 13:25] Ankit kothari
Sorry for the lack of understanding, windows 2007.
[15 Sep 2015 6:45] Chiranjeevi Battula
Hello Ankit kothari,

Thank you for the bug report.
Verified this behavior on MySQL for Excel 1.3.4 version in Windows 7 professional 32 bit.

[15 Sep 2015 6:47] Chiranjeevi Battula

Attachment: 78419.zip (application/zip, text), 201.79 KiB.

[15 Sep 2015 7:46] Ankit kothari
Saw the screenshots, that is exactly what I'm facing.
[24 Sep 2015 10:24] sachin sharma
I am facing similar problem. System details
Windows 7 Professional-64 bit(SP1)
MySQL for Excel Version 1.3.4
[1 Oct 2015 19:53] Javier TreviƱo
Your screenshots look like you used Excel 2007 for your test.

Please review the last comment on bug http://bugs.mysql.com/bug.php?id=71426.

It is very possible that the problem you are seeing is because not all Windows + Office updates have been installed, and there is a Microsoft hotfix automatically installed by Windows or Office update that fixes the limitation of using COM add-ins for all users in Office 2007.

If this is the case this bug should be a duplicate of 71426 and nothing to fix in code.
[20 Oct 2015 12:24] Chiranjeevi Battula
Duplicate/related with http://bugs.mysql.com/bug.php?id=71426