Re: Connecting Excel to mySQL on worksheet open

[Andrew Ogilvie]

Thanks again Javier,

When I open the "Manage Stored Import and Edit Connection Information" settings, the worksheet I am having trouble with does not show up. I have three data sets I am connecting to this one workbook (different sheets).

When I reimport the data, the connections do all show up as expected.

If I save the file and open the settings.config file, the correct lines are listed in the <ImportConnectionInfosList>.

Still after closing and reopening the connection is broken.

One thing I just thought of, and sorry for not mentioning it before, is that this spreadsheet is on a network location, rather than local. The address never changes, but could this be an issue?

Thanks again, I appreciate the effort.

Andrew