Bug #73182 Edit and Import sessions are not saved in Office 2007 Win7x64
Submitted: 2 Jul 2014 20:35 Modified: 1 Aug 2014 1:58
Reporter: Javier Rivera Zavala Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.1 OS:Any
Assigned to: CPU Architecture:Any

[2 Jul 2014 20:35] Javier Rivera Zavala
Description:
MySQL for Excel does not save connection information for edit sessions or imports when working on Windows 7(x64).

How to repeat:
1. Open Excel 2007 in a Windows 7 x64 machine.
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. Save the workbook.
7. Close Excel.
8. Reopen the workbook.
9. You need to reopen the MySQL for Excel panel[Repeat steps 2 and 3].
10. No message prompt about restoring sessions appear.

You could also try with import sessions but it can only be verified by opening the settings.config file at %appdata%\Oacle\MySQL for Excel\ and looking at the corresponding tag.

At short, it looks like the Wokbook_AfterSave event code is never hit under this conditions though the Wokbook_BeforeSave event is.
[5 Jul 2014 1:13] Javier Rivera Zavala
Posted by developer:
 
Code was added to trigger WorkbookAfterSave events in Office 2007 artificially.
[1 Aug 2014 1:58] Philip Olson
Fixed as of the upcoming MySQL for Excel 1.3.2 release, and here's the changelog entry:

On Windows 7 (x64) with Excel 2007, MySQL for Excel did not save connection
information for edit sessions or data imports.

Thank you for the bug report.