MySQL Bugs: #81901: MySQL for excel v1.3.6

Bug #81901	MySQL for excel v1.3.6 - refresh all
Submitted:	17 Jun 2016 9:00	Modified:	5 May 2017 19:33
Reporter:	Tim De Cremer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.6	OS:	Windows (windows 7 - excel 2010)
Assigned to:		CPU Architecture:	Any
Tags:	MySQL for Excel, Refresh All

Description:
In excel, I have also connections to external CSV files.

With the button "refresh all" in excel, normally those files are also refreshed,
since the installation of the addon MySQL for excel V1.3.6. they aren't updated anymore. For the external data the refresh ALL doens't work, only the MySQL data is refreshed.

When I select my specific external data and click on the refresh button, the external data is refreshed.

Someting in the addon is messing with the main "Refresh ALL" button.
On PC's on our company where my collegues haven't installed this addon, this refresh (in exacly the same file)feature works.

(If the addon is installed previously, the bug is still present, uninstalling the addon doens't fix the problem...)

How to repeat:
Create csv file with random data.
Create new excel file.
Link the data with "external data" functionality in excel.
Refresh with the MAIN refresh ALL button in excel.
Now the data of the csv file is in your new excel file.

Install now the Addon MySQL for excel.
Load data from a mysql database in the excel file.

Change the initial CSV file and change data in the mysql database,
click on REFRESH ALL button.
Only the mySQL data will be refreshed.

Suggested fix:
Manually refresh each external link is a workaround.

Hello  Tim De Cremer,

Thank you for the bug report and steps.
Verified this behavior on MS Excel 2013 with MySQL for Excel 1.3.6.

Thanks,
Chiranjeevi.

Posted by developer:
 
Changed the way the Refresh All is overridden by MySQL for Excel, in previous versions the Refresh All was looping through all Excel tables (ListObjects) and PivotTables found in every Excel Worksheet and refreshed their contents.
Now the Refresh All is overridden to loop through all Workbook connections, any connection created by MySQL for Excel to refresh imported data is handled internally by the add-in, the rest of the connections are refreshed in the standard way.

Posted by developer:
 
Fixed on 1.3.7 build 2

Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.7 release, and here's the changelog entry:

Although the Refresh All action in the Data ribbon refreshed all MySQL
connections, it did not refresh the other connections associated with a
workbook when the MySQL for Excel add-in was enabled.

Thank you for the bug report.