Re: Connecting Excel to mySQL on worksheet open

[Javier Treviño]

Hi Andrew,
What comes to mind is the fact that MySQL for Excel currently has a known limitation in the way it handles Workbook Connection information.

As you can see it is storing it in the settings.config file and it stores the Workbook location. If you take the Workbook and move it somewhere else, then the "link" is broken... so as you can see this needs to be enhanced so the "link" is not broken when the Workbook is moved to a different location.

Can you please inspect the <ImportConnectionInfosList>, locate the ExcelTableName you are trying to Refresh and tell me if the WorkbookFilePath is not corresponding to the path the file currently has?

Currently you can go to the Global Options (accessible after you connect to a mysql server, using the "Options" button at the bottom of the side-bar), and click on "Manage Stored Import and Edit Connection Information..." and see what entries there are in red, those ones have "missing" or "broken" links.

You can try editing the information yourself in the settings.config and see if that fixes the link.

Best regards.

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