MySQL Forums
Forum List  »  MySQL for Excel

Update Pivot Table Data
Posted by: Jason Barrett
Date: February 16, 2016 02:55PM

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?

Options: ReplyQuote

Written By
Update Pivot Table Data
February 16, 2016 02:55PM
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.