Bug #78941 MySQL for Excel 1.3.4 (and 1.3.5): HRESULT: 0x800A03EC upon "Refresh All"
Submitted: 23 Oct 2015 13:22 Modified: 15 Dec 2015 22:28
Reporter: Oliver Lowson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.5.0 for Excel 2007 (12.0.6732.5000) OS:Microsoft Windows (Windows 7 Professional 6.1.7601 SP 1 Build 7601 (x64-based))
Assigned to: CPU Architecture:Any
Tags: 0x800A03EC, HRESULT: 0x800A03EC, Refresh All

[23 Oct 2015 13:22] Oliver Lowson
Description:
When MySQL for Excel is installed and enabled, Excel's built-in 'Refresh All' button now causes an exception from MySQL for Excel - even if there are no MySQL data sources in the file.

How to repeat:
1 - Open a new instance of Microsoft Excel (with MySQL for Excel enabled)
2 - In the first sheet of the new book, cell A1, type 'My heading' and in cell A2 'My Data', then select the two cells.
3 - On the 'Home' tab choose 'Format as Table' and set any style, accepting that your table has headers.
4 - On the 'Data' tab choose 'Refresh All'
5 - HRESULT: 0x800A03EC is returned

Suggested fix:
I don't know enough about the system to contribute anything helpful here, but perhaps the MySQL script could check that the table is indeed a MySQL table before returning the error? Or just handle the exception?
[23 Oct 2015 13:24] Oliver Lowson
Just so you know, I have already looked at http://forums.mysql.com/read.php?172,630324,630324#msg-630324 and http://bugs.mysql.com/bug.php?id=73467, which are both slightly different issues.
[26 Oct 2015 10:08] Oliver Lowson
Updated to reflect that this issue is still present in 1.3.5
[28 Oct 2015 10:40] Miguel Solorzano
Message error

Attachment: excel_for_windows_135.png (image/png, text), 96.56 KiB.

[28 Oct 2015 10:40] Miguel Solorzano
Thank you for the bug report.
[5 Nov 2015 17:32] Javier Treviño
Posted by developer:
 
Fixed the way MySQL for Excel does the custom Refresh All action for Excel ListObjects, the method to refresh the ListObject when the data source is a QueryTable was incorrect.
[5 Nov 2015 17:53] Javier Treviño
Posted by developer:
 
The correct fix message is this:

Fixed a problem when Refresh All was done so that the Refresh method is not called for Excel ListObjects that have an Excel range as their data source, since that throws a COM Exception.
[10 Nov 2015 12:14] Oliver Lowson
Thanks very much for looking into this.

Ollie
[15 Dec 2015 22:28] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.6 release, and here's the changelog entry:

The MySQL for Excel Refresh All function would throw an unhandled
exception.

Thank you for the bug report.