Adding to an existing Pivot Table
in [General]
|
Prev: Floating Cells
Next: Count Dates & Return as %
From: Jim Thomlinson on 19 May 2010 13:06 Right click the pivot table and click the Wizard option. Use teh back button to get to the data source range. -- HTH... Jim Thomlinson "chilvers.s" wrote: > I am using Excel 2003, where do I go? > > "Eduardo" wrote: > > > Hi, > > go to the pivot table, is under options, data, click anywhere in it, at the > > too you will see PivotTable tools in palid red, xlick on it, just under it > > you will see change data source > > > > "chilvers.s" wrote: > > > > > where is the change source area? > > > > > > "Eduardo" wrote: > > > > > > > Hi, > > > > yes, you have to go to the pivot table, and click in the Change source area, > > > > it will take you to your original selection, then just extend the range > > > > > > > > "chilvers.s" wrote: > > > > > > > > > If I have created a pivot table and later add more rows of data to the main > > > > > sheet (which the pivot table was created from), is there a way to update the > > > > > pivot table (change the range of cells that the pivot table is referring to > > > > > so that the pivot table now includes the new rows of data)?
From: Eduardo on 19 May 2010 13:31 Hi, click on the pivot table wizard, and then the back to get to the range "chilvers.s" wrote: > I am using Excel 2003, where do I go? > > "Eduardo" wrote: > > > Hi, > > go to the pivot table, is under options, data, click anywhere in it, at the > > too you will see PivotTable tools in palid red, xlick on it, just under it > > you will see change data source > > > > "chilvers.s" wrote: > > > > > where is the change source area? > > > > > > "Eduardo" wrote: > > > > > > > Hi, > > > > yes, you have to go to the pivot table, and click in the Change source area, > > > > it will take you to your original selection, then just extend the range > > > > > > > > "chilvers.s" wrote: > > > > > > > > > If I have created a pivot table and later add more rows of data to the main > > > > > sheet (which the pivot table was created from), is there a way to update the > > > > > pivot table (change the range of cells that the pivot table is referring to > > > > > so that the pivot table now includes the new rows of data)?
From: Roger Govier on 19 May 2010 16:22
Hi Since you are using XL2003, first create a List. Place your cursor within the source data>Data>list>Create lists>click my data has headers. Then Data>pivot Tables>finish and create your PT The List will grow dynamically as you add or delete rows from your source table, Alternatively, create a Dynamic range. Insert>name>Define> Name myData Refers to =$A$1:INDEX($1:$65536,COUNT($A:$A),COUNT($1:$1)) On your existing PT>place cursor with PT>right click>PT Wizard>back>Source =myData>Finish -- Regards Roger Govier chilvers.s wrote: > I am using Excel 2003, where do I go? > > "Eduardo" wrote: > >> Hi, >> go to the pivot table, is under options, data, click anywhere in it, at the >> too you will see PivotTable tools in palid red, xlick on it, just under it >> you will see change data source >> >> "chilvers.s" wrote: >> >>> where is the change source area? >>> >>> "Eduardo" wrote: >>> >>>> Hi, >>>> yes, you have to go to the pivot table, and click in the Change source area, >>>> it will take you to your original selection, then just extend the range >>>> >>>> "chilvers.s" wrote: >>>> >>>>> If I have created a pivot table and later add more rows of data to the main >>>>> sheet (which the pivot table was created from), is there a way to update the >>>>> pivot table (change the range of cells that the pivot table is referring to >>>>> so that the pivot table now includes the new rows of data)? |