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:
None 
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
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.