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
• Status: Not a Bug
• Category: MySQL for Windows: MySQL for Excel
• Severity: S1 (Critical)
• Version: latest
• OS: Windows (Windows 10)
• 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.