Prev: Floating Cells
Next: Count Dates & Return as %
From: chilvers.s on 19 May 2010 10:38
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 10:45
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: chilvers.s on 19 May 2010 11:13
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 11:24
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: chilvers.s on 19 May 2010 11:43
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)?
 |  Next  |  Last
Pages: 1 2
Prev: Floating Cells
Next: Count Dates & Return as %