MySQL Bugs: #75900: WARNING ABOUT MACRO-FREE WORKBOOKS WHEN CLOSING & SAVING AN EXCEL 2007 WORKBOOK

Bug #75900	WARNING ABOUT MACRO-FREE WORKBOOKS WHEN CLOSING & SAVING AN EXCEL 2007 WORKBOOK
Submitted:	13 Feb 2015 22:00	Modified:	28 Feb 2015 21:33
Reporter:	Javier Treviño	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.3	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
A pop-up warning message stating some features can't be saved in a macro-free workbook appears when closing a Workbook that has not been saved.
The features that can't be saved are functions stored in defined names that are added by MySQL for Excel to handle some internationalization issues.

Related to Bug #19358961 which was fixed only for Excel 2010 and later.

How to repeat:
1. Open MS Excel 2007.
2. Select the Data tab from the ribbon
3. Click the MySQL for Excel Icon and open the panel.
4. Open a connection, select an schema and click over any table.
5. Click on Edit session.
6. Close Excel, a message asking if you want to save the workbook will be
displayed, select Yes.
7. A new pop-up message stating some features can't be saved in a macro-free
workbook will appear. This should not appear since no formulas were
explicitly added in the first 6 steps.

Suggested fix:
The defined names that are added by MySQL for Excel to handle some internationalization issues should be removed before saving the workbook, and added again during the session of MySQL for Excel.

Posted by developer:
 
Fixed the logic that runs before an Excel workbook is saved to remove the defined Excel names used for localized date formats before running the custom after save logic for Excel 2007.

Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.4 release, and here's the changelog entry:

For Excel 2007, a pop-up warning message incorrectly stated that some
features could not be saved in a macro-free workbook would appear when
closing a Workbook that was not saved.

Thank you for the bug report.