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)?

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)?

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)?

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)?

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)?

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)?

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)?

Hi

Since you are using XL2003, first create a List.
Place your cursor within the source dataDatalistCreate listsclick my
data has headers.
Then Datapivot Tablesfinish and create your PT

The List will grow dynamically as you add or delete rows from your
source table,

Alternatively, create a Dynamic range.
InsertnameDefine
Name myData
Refers to =$A$1:INDEX($1:$65536,COUNT($A:$A),COUNT($1:$1))

On your existing PTplace cursor with PTright clickPT
WizardbackSource =myDataFinish
--
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)?