Update Pivot Table Data
I have created Pivot Tables in MS Excel 2016 that reference the data retrieved via the mySQL for Excel Add In. When I re-open the Excel sheet, I can reconnect to the database and refresh the data, the new data is visible in the Excel sheet.
When I look to refresh the Pivot Table (and Pivot Charts) I get the message "Reference not Valid". I can see on the Data...Connections window that new connections are being made by MySQL with a number suffix e.g. database.table 1, database.table12 where the "table1" etc is not present in the MySql database.
How can I get the Pivot Table to refresh?
Subject
Views
Written By
Posted
Update Pivot Table Data
2167
February 16, 2016 02:55PM
1192
February 22, 2016 05:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.