Updating pivot table data
And in Excel 2003 this set of steps works great: The new pivot chart (on the copied sheet) retains its link to the pivot table on its parent worksheet, so it updates as soon as the pivot table is refreshed.But in Excel 2007, these steps don’t work the same way.But the new chart cannot be linked to the new pivot table. My colleague Bill Manville wrote to me about this problem, citing an old forum post in which I doubted this could ever be solved. When this happens, the pivot table still links to the original data, but the chart becomes unlinked from the pivot table.In fact, the chart changes back from a pivot chart to a regular chart.
This allows the pivot table to expand its source automatically by refreshing it.If, like me, this is not the case for you, then hopefully you will find this article informative and helpful.I will present a basic tutorial on creating, editing, and refreshing pivot tables in Google Sheets.Also see our article How To Add a Chart and Edit the Legend in Google Sheets First, let’s talk about what a pivot table is.A pivot table summarizes the data from another table by performing some kind of manipulation on the original data (such as summing, counting, or averaging), and then groups the summarized data in a useful way.