Bug #84291 Error refreshing MySQL data when the add-in's sidebar is not visible

Description:
An error occurs trying to refresh imported MySQL data when the MySQL for Excel sidebar is not visible.
The error thrown reads something like:

An error ocurred trying to refresh MySQL data in the Excel table "xxx.yyy".
Object reference not set to an instance of an object.

There is also a typo in the error message in "ocurred" which should read "occurred".

How to repeat:
1. Open Excel
2. Click on the MySQL for Excel button in the Data ribbon to show the sidebar.
3. From the side panel, double-click a connection, select a schema and any table
4. Click on Import MySQL Data
5. Make sure in the Advanced Options the option to create an Excel table for the imported data is checked
6. Import the data
7. Click on the MySQL for Excel button in the Data ribbon to hide the sidebar.
8. Right-click on any Excel cell within the imported region, select "Refresh"
9. Note the error message is thrown.
10. Click on the MySQL for Excel button in the Data ribbon to show the sidebar.
11. Right-click on any Excel cell within the imported region, select "Refresh"
12. Note no error appears.

Posted by developer:
 
Fixed the refreshing code to avoid attempting to update properties in the sidebar if it is not visible.

Posted by developer:
 
Still failing on 1.3.7 build 2

Posted by developer:
 
Moved code that was clearing connection information when hiding the sidebar to the point when the add-in is shutdown instead.

Posted by developer:
 
Fixed on 1.3.7 build 3

Posted by developer:
 
Attempting to refresh MySQL data in an Excel worksheet while the MySQL for Excel task pane was closed generated an error.