Bug #76475 Changes in workbook not saved when closing Excel window
Submitted: 24 Mar 2015 17:52 Modified: 23 Oct 2015 0:25
Reporter: James Carson Email Updates:
Status: Closed Impact on me:
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:1.3.4 OS:Any
Assigned to: CPU Architecture:Any

[24 Mar 2015 17:52] James Carson
When closing a workbook where data has been uploaded into the MySQL database and refreshed but not saved, answering 'Save' to the question about saving changes wipes out the connections in the workbook to the database. 

How to repeat:
1> Open workbook with 'View' connections to MySQL database. 
2> Upload data into database (TOAD), not from inside Excel. 
3> 'Refresh All', but do NOT save the workbook. 
4> Close the workbook. 
5> Answer 'Save' to the save changes question. 
Re-open workbook and the connections are gone.
[29 May 2015 21:46] Javier Treviño
Changing subject to reflect more accurately the problem.
[29 May 2015 21:54] James Carson
The problem is not only that the changes are not saved. Note that the connections are wiped out and have to be re-constructed.
[15 Oct 2015 1:24] Javier Treviño
Posted by developer:
Fixed a bug where connection information objects were being cleaned up from memory when an Excel Workbook was being closed, but the cleanup was happening before the Workbook was saved causing that no connection information created after the last save was found to write to disk. Now the cleanup happens correctly after the Workbook is actually saved.
[23 Oct 2015 0:25] Philip Olson
Posted by developer:
Fixed as of the upcoming MySQL for Excel 1.3.5 release, and here's the changelog entry:

Connection information created after the last save was cleared from
memory when an Excel Workbook was closed, thus causing the connection
information to not write to disk. Now the connection cleanup happens after
a Workbench is saved, thereby saving the new connection information.

Thank you for the bug report.