Bug #83987 MySQL for Excel appears to hang after pressing Export Excel Data to New Table
Submitted: 28 Nov 2016 14:03 Modified: 30 Nov 2016 13:17
Reporter: James Schrage Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S1 (Critical)
Version:latest OS:Microsoft Windows (Windows 10)
Assigned to: CPU Architecture:Any

[28 Nov 2016 14:03] James Schrage
Description:
MySQL for Excel addon for Microsoft Excel 2016 appears to hang after selecting a connection and then a schema database and then pressing the Export Excel Data to New Table link.  No response occurs, the MySQL for Excel seems dead.

How to repeat:
MySQL for Excel addon for Microsoft Excel 2016 appears to hang after selecting a connection and then a schema database and then pressing the Export Excel Data to New Table link.  No response occurs, the MySQL for Excel seems dead.

Suggested fix:
No fix known at this time - appears to be a bug.
[29 Nov 2016 17:58] James Schrage
Ok I found what was causing the hang.  I noticed that the spreadsheet workbook was in both compatibility mode and shared mode.  I removed both compatibility mode and shared mode and the export excel to MySQL worked.  Thank you!
[30 Nov 2016 13:17] Chiranjeevi Battula
Hello James Schrage,

Thank you for the bug report.
I'm glad that you found a solution for your problem and let us know if you are still having the issue with complete repeatable steps.

Thanks,
Chiranjeevi.