Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Source
I have a pivot table already created; the data source is the next worksheet.
Since then I added some data outside the data source by addicg some rows of data to the bottom of the data source. Can the data source for the existing pivot table be change to include these added rows (if so, how) or do I need to delete this pivot table and create a new pivot table via the wizard to include all new data? Thanks in advance for help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Source
You can just click anywhere in the pivot table, then on the Pivot Table
toolbar click Pivot Table Wizard...then just hit the "<Back" button until you get to the part of the wizard where you declare your data source and change it to the new range. Even better, use dynamic name ranges in your data source and point to that instead. For example, on your data source sheet, go to Insert Name Define and add a name called PTData and have it refer to this formula: =OFFSET(Sheet1!$A$1,0,0,COUNTA($A:$A),COUNTA($1:$1 )) assuming your data starts in A1. Now it will count how many rows are used (by counting down column A) and will count how many headers you have in row 1 and adjust the data source accordingly. Go back to your Pivot Table data source box in the wizard and type: =Sheet1!PTData -- Please remember to indicate when the post is answered so others can benefit from it later. "evoxfan" wrote: I have a pivot table already created; the data source is the next worksheet. Since then I added some data outside the data source by addicg some rows of data to the bottom of the data source. Can the data source for the existing pivot table be change to include these added rows (if so, how) or do I need to delete this pivot table and create a new pivot table via the wizard to include all new data? Thanks in advance for help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table source data | Excel Discussion (Misc queries) | |||
Data source for pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Data Source | Excel Discussion (Misc queries) | |||
Pivot Table Source Data | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |