I have created a pivot table to extract iformation from a data base. I have
now added to the data base therfore I need to expand the renge for the table
to read from.

Is there a way of doing this without having to set up the Pivot table again.

Thank you
--
pk

Hi
you can give a name to your data base. [ block the data base, ALT-I, NAME,
GIVE A NAME ]. Then go to pivot wiz, click back, enter the NAME, click NEXT &
FINISH, Refresh data. Then it will work.

TIP: always name the range with one row extra and input new data by
inserting rows before the last row you have defined, thereby it takes care.

"PK" wrote:

I have created a pivot table to extract iformation from a data base. I have
now added to the data base therfore I need to expand the renge for the table
to read from.

Is there a way of doing this without having to set up the Pivot table again.

Thank you
--
pk

You can use a dynamic data source for the pivot table, as described he

http://www.contextures.com/xlPivot01.html

PK wrote:
I have created a pivot table to extract iformation from a data base. I have
now added to the data base therfore I need to expand the renge for the table
to read from.

Is there a way of doing this without having to set up the Pivot table again.

Thank you


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html