Updating source data for pivot table

This guide assumes that you have already created a pivot table, but that you have recently updated the data that was used to generate the pivot table.Following these steps will cause the pivot table to check the source data again and update itself accordingly. Step 2: Make any changes to your original source data that you would like to be reflected in your pivot table.However, when you refresh the pivot table after making the changes, the renamed field will disappear from the pivot table layout.In our example, the Qty field is removed from the layout.Most commonly you have a worksheet with a bunch of data and a corresponding chart, and you have another sheet of data you want to add a chart to.Copying and pasting the chart onto the new sheet requires you to change links in the chart, usually series by series. But the article above describes an easier way: The chart on the new worksheet updates as soon as the new data is pasted into place.If you had number formatting in the old pivot field, you’ll have to reapply the number formatting you had previously applied.

updating source data for pivot table-63updating source data for pivot table-71updating source data for pivot table-70updating source data for pivot table-29

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.It isn’t automatically replaced by the Quantity field, even though it’s in the same column heading cell in the source data.If you change the column headings, you’ll have to add the revised field to the pivot table layout again.In a previous post: How to create a dynamic pivot table and refresh automatically I demonstrated how to refresh a pivot table when a sheet is activated.This post describes how to refresh a pivot table when data is edited/added or deleted on a specific worksheet.

Leave a Reply