Bug #68296 MySQL for Excel sidebar does not appear in Excel 2013, works in Excel 2007
Submitted: 7 Feb 2013 0:47 Modified: 7 Feb 2013 4:36
Reporter: Tom Raggett Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:1.1.0 OS:Microsoft Windows (8 Pro)
Assigned to: CPU Architecture:Any
Tags: 2007, 2013, Excel, sidebar

[7 Feb 2013 0:47] Tom Raggett
Description:
I installed Microsoft Office 2013 Preview on Windows 8 Pro.

I then installed Microsoft Office 2007 alongside as a couple of (non-SQL) add-ins did not work in Excel 2013. Both installations function fully; Office 2007 is set to default open Office files - NB I can't seem to change this. 

I installed MySQL for Excel 1.1.0.

The add-in works as expected in Excel 2007 SP3 and will connect successfully to a connection to MySQL running on QNAP NAS box set up in MySQL Workbench (5.2.44 CE).

In Excel 2013 I see the MySQL for Excel button in the Data Ribbon, but when I click it, it changes status (enabled / disabled) but the sidebar does not appear. I would expect the sidebar to appear.

There is nothing that appears of any use in the log file. There are only entries for startup and shutdown which correspond to starting and exiting Excel 2013, e.g. "MySQLForExcel Information: 1 : MySQL for Excel Startup" with a timestamp. 

The addin is listed as an active COM addin in both versions of Excel.

In Excel 2013, Options>Add-ins>Active Application Add-ins  shows MySQL.ForExcel of type COM Add-in:

Add-in: MySQL.ForExcel
Publisher: <None>
Compatibility: No compatibility information available
Location: C:\Program Files (x86)\MySQL\MySQL For Excel 1.1.0\MySQL.ForExcel.vsto|local
Description: MySQL.ForExcel

In Excel 2007, it appears exactly the same, only without the Compatibility line.

The MySQL ribbon button is showing in Excel 2013, so the add-in is loading (and the log file and button confirm this), but the click behaviour does not bring up a sidebar (or at least not one I can see on screen).

How to repeat:
Install Office 2013 preview.
Install Office 2007
Install MySQL for Excel 1.1.0

Open workbook in Excel 2013.
Change to data ribbon.
Click MySQL for Excel button.
Sidebar does not appear (sidebar should appear if working correctly).

Confirm sidebar appears in Excel 2007.
[7 Feb 2013 4:36] Tom Raggett
NB I have now fixed this.

Uninstall Office 2013 preview
Repair Office 2007
Install Office 2013 365 Home Premium
Run fix-it at http://support.microsoft.com/kb/211494
Turn on and then off "Ignore DDE" in File>Options>Advanced>General in Excel.

Result: MySQL sidebar appears when ribbon button is clicked, as expected.