Bug #75565 Pivot Table Refresh All Not Working
Submitted: 20 Jan 2015 20:05 Modified: 4 Mar 2015 23:51
Reporter: Jonathan Brown Email Updates:
Status: Closed Impact on me:
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.3 OS:Microsoft Windows (Windows 7 Professional SP 1)
Assigned to: CPU Architecture:Any
Tags: excel 2013

[20 Jan 2015 20:05] Jonathan Brown
When I have the MySQL for Excel add-in active, Refresh All for pivot tables does not work. I can refresh individual pivot tables but not all of them at once.

My documents have no connections to the database and if I deactivate the add-in, everything works fine.

How to repeat:
Have MySQL for Excel 1.3.3 add-in active.

Try to Refresh All pivot tables.
[27 Jan 2015 13:29] Jonathan Brown
Is there any way to fix this? I keep having to disable and re-enable the add on to work around.
[11 Feb 2015 21:41] Javier Treviño
Hi Jonathan,
Thanks for your bug report.

There is no workaround for this bug other than disabling the add-in or refreshing individually each PivotTable.

I see you are already subscribed to this bug, so you'll get a notification when the bug status changes.
[12 Feb 2015 6:00] Javier Treviño
Posted by developer:
Fixed the custom Refresh All functionality overriden by MySQL for Excel to fire a refresh not only to Excel tables (ListObjects) but also to Pivot Tables.
[12 Feb 2015 15:03] Jonathan Brown
Thanks. When will this fix be released?
[13 Feb 2015 17:54] Javier Treviño
Posted by developer:
This fix will be released with the 1.3.4 version aimed to be released by ends of February.
[4 Mar 2015 23:51] Philip Olson
Posted by developer:
Fixed as of the upcoming MySQL for Excel 1.3.4 release, and here's the changelog entry:

The "Refresh All" action did not function for pivot tables. Each pivot
table had to be individually updated.

Thank you for the bug report.