Updating source data for pivot table
Whenever you change the information in your source data table, you will need to update the Pivot Table.There is no need to recreate the table, instead you simply select a cell in the Pivot Table and then select Refresh Data from the Data menu, or click on the Refresh Data tool on the Pivot Table toolbar.Occasionally, you might need to change a column heading in the pivot table’s source data.For example, you could change a column heading from Qty to Quantity, to make it easier to understand.Step 3: Select the tab at the bottom of the worksheet that contains the pivot table. Step 5: Click the Analyze tab at the top of the window. Note that, rather than clicking the Refresh button in the ribbon to update your pivot table data, you can choose to press the F5 key on your keyboard instead.Do you need to print your spreadsheets, but something is preventing that from being simple?
However this article solves your problems using an excel defined table and a small amount of event code.Well, knowing the above protocol, you’d think you could copy the worksheet, change the data, and the chart would be fine.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.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.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.