Bug #78910 Excel add-in does not save data when Excel is closed
Submitted: 21 Oct 2015 21:00 Modified: 15 Dec 2015 22:45
Reporter: Rafael Antonio Bedoy Torres Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.4 OS:Any
Assigned to: CPU Architecture:Any

[21 Oct 2015 21:00] Rafael Antonio Bedoy Torres 
Description:
Excel add-in does not save data when Excel is closed **ONLY USING OFFICE 2007**

How to repeat:
**ONLY USING OFFICE 2007**
1. Open Excel and open Excel Add-in.
2. Use a valid connection and Import any Table.
3. Close Excel.
4. Excel will ask if want to save the book.
5. Click Yes.

Results:

Excel gets closed without saving any data.
[10 Dec 2015 20:57] Javier Treviño 
Tweaked the code that runs when closing an Excel workbook to disable events
for Excel 2007 only while the workbook is being saved. This fixes a problem
where MySQL for Excel offered to save an unsaved Excel workbook when closing
it, but the save was not happening causing all unsaved changes to be lost.
[15 Dec 2015 22:45] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.6 release, and here's the changelog entry:

With Office 2007, data would not auto-save after closing Excel.

Thank you for the bug report.