Pivot Table How To Change Data Range
Refreshing the pivot table will not pull in the extra days data as the data range is still fixed.
Pivot table how to change data range. You can update this by clicking on the pivot table and then choosing options change data source but it s an additional task to remember and if you have multiple pivot tables pulling from the same data range it is quite time consuming. Now you have a dynamic range to create a pivot table. All you have to do is just create a pivot table with your source data and after that change the source with the named range using the same method which i have used in the first method of tables. Click on the ok.
In the data group click on change data source button. Select the options tab from the toolbar at the top of the screen. Now the pivot table is. As you can see in above image the table range field refers to sales jan worksheet and clicking on sales feb will change data source for pivot table to the new worksheet.
Click the next button until you see the screen with the source data range. How do i change the data source for an existing pivot table. Then in the pop up dialog select the new data range you need to update. Please follow the below steps to update pivot table range.
After you change the data range click the relative pivot table and click option in excel 2013 click analyze change data source. In pivot table data source dialogue box that appears click in table range box and click on the worksheet containing new source data. In excel 2003 launch the wizard utility by right clicking inside the pivot table and choosing wizard from the pop up menu.
