Bug #88560 COM Add-In "MySQL For Excel" when enabled causes new, blank workbook to open

• Submitted: 20 Nov 2017 16:43
• Modified: 21 Nov 2017 15:19
• Reporter: Mike Caskey
• Status: Duplicate
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.3.7
• OS: Windows (Windows 10 Ent. Build 1703)
• CPU Architecture: Any

[20 Nov 2017 16:43] Mike Caskey

Description:
In MS Excel 2013 or 2016, when the MySQL for Excel COM Add-in is enabled and a user clicks an exiting Excel file (shortcut) to open, it generates an additional, blank workbook prior to opening the selected Excel file. If the COM Add-in is disabled, and the file opening process is repeated the additional blank workbook does not open.

This does not occur when simply opening an initial Excel instance or additional Excel files when an instance is already opened. It appears to only occur once and when a file is opened from a shortcut (aka Desktop, folder or from recents list).

It also labels the additional workbook as "Sheet1" whereas if Excel is opened, then a file is opened, that first workbook is labeled as "Book1". Slight difference but a difference.

How to repeat:
To replicate error, open Excel, go to File -> Options -> Add-ins -> Manage: select "COM Add-ins" from the dropdown list then click "Go..."

From the list, select or check the "MySQL for Excel" add-in, click "Ok", then close Excel. Open an Excel file and the additional blank workbook will appear.

Suggested fix:
Unable to locate a preference setting or configuration that calls out specifically to open a blank workbook upon file opening.

[21 Nov 2017 7:36] Chiranjeevi Battula

Hello Mike Caskey,

Thank you for the bug report.
This is most likely duplicate of Bug #86633, please see Bug #86633

Thanks,
Chiranjeevi.

[21 Nov 2017 15:19] Mike Caskey

Glad to see its already on the list. Thanks!

[3 Jan 2018 11:32] preckrasno preckrasno

but how to solve this problem, if i need to use mysql plugin for excel.

[3 Jan 2018 16:40] Don Emery

Has anyone determined if there is a workaround besides uninstalling or disabling the addin?

[15 Apr 2018 9:27] nigel Roth

as at 2018-04-15, still not fixed for v1.3.7, win 8.1, excel 2010, but v1.3.6 does work

[25 Oct 2018 16:21] Randy Pool

1.3.7 opens a blank workbook on Windows 7 using Excel 2010.