MySQL Forums
Forum List  »  MySQL for Excel

Re: Save Connection to XLSX
Posted by: Javier Treviño
Date: November 23, 2015 12:33PM

Hi Mark,
Thanks for writing in our forums.

As of the current version of MySQL for Excel, when you open an Edit Data session (meaning you select a MySQL table and click on Edit MySQL Data) and save the Excel Workbook, the connection information is stored for your user in your user's application data directory. The next time the Excel file is opened and MySQL for Excel is accessed, a prompt is shown asking if you wish to open the Edit Data sessions that were open when the file was last saved. This is as per design and have several shortcomings that we intend to address in a future version.

Right now the connection information is saved into the settings file, and it ties the Excel Workbook with the connection needed to access the MySQL table being edited, and it is stored as I explained for the current user.

This means that if another user on the same computer opens the Excel Workbook, the connection won't be automatically established. Also means if the Excel Workbook is moved to a different location, the connection won't be automatically opened either.

We intend to improve the way we save these sessions so that they are embedded within the Excel file, so if the file is moved or opened in a different computer, the connection can be established.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
2018
November 19, 2015 05:08AM
Re: Save Connection to XLSX
1173
November 23, 2015 12:33PM
956
December 09, 2015 09:10AM
1154
December 11, 2015 01:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.