MySQL Bugs: #89387: Data cannot be longer refreshed after renaming of Excel-Sheets

Bug #89387	Data cannot be longer refreshed after renaming of Excel-Sheets
Submitted:	24 Jan 2018 15:51	Modified:	24 May 2019 22:57
Reporter:	Oliver Busa	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.7	OS:	Windows (Windows 7 (x64) / MS Excel 2013 (v15.0.4971.1000))
Assigned to:		CPU Architecture:	Any

Description:
Data of a connected MySQL database can't be refreshed any longer if the sheet is renamed after import. If a second table is imported a data refresh fails with the following error message. "An error occured trying to refresh data in Excel table...".

How to repeat:
1. Open an empty Excel sheet and import MySQL data into the sheet.
2. Save the file and reopen to verify that the data is refreshed by using "Data" - "Refresh all data" (not sure if this is the correct translation as I use a German Excel).
3. Rename the Excel sheet which contains the MySQL data and try to refresh the data which no longer works.
4. Import further data to a second Excel sheet and try refresh again. Now MySQL for Excel will show the following error message.

"An error occured trying to refresh data in Excel table..."

"This error is most likely happening because data was imported from a MySQL table or view, and when the Excel Workbook was saved MySQL for Excel could not store the connection information necessary to refresh the data of the Excel table (ListObject).

In order to avoid receiving this error message each time the Excel table is refreshed, please delete the Excel table and import the data again before saving the Excel Workbook."

5. Renaming the sheet back to it's original fix the issue after a the file is closed and reopened again.

Hello Oliver Busa,

Thank you for the bug report.
Verified this behavior on MS Excel 2016 with MySQL for Excel 1.3.7.

Thanks,
Chiranjeevi.

Screenshot

Attachment: Bug_89387.PNG (image/png, text), 153.38 KiB.

Fixed as of the upcoming MySQL for Excel 1.3.8 release, and here's the changelog entry:

Data imported to a worksheet could not be refreshed if the worksheet was
renamed after the import operation. The add-in now inspects the connection
information of imported tables to determine whether the associated
worksheet name changed, and if so, it updates the connection metadata.
Also, it removes the connection information for missing or deleted
worksheets.

Thank you for the bug report.