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.
