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
• Status: Duplicate
• Category: MySQL for Windows: MySQL for Excel
• Severity: S1 (Critical)
• Version: 1.3.4
• OS: Windows (Professional)
• CPU Architecture: Any

[12 Sep 2015 22:10] Ankit kothari

Description:
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.

Thanks,
Chiranjeevi.

[15 Sep 2015 6:47] Chiranjeevi Battula

screenshots.

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

Chiran,
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