software

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 amp;
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.

quot;PKquot; wrote:

gt; I have created a pivot table to extract iformation from a data base. I have
gt; now added to the data base therfore I need to expand the renge for the table
gt; to read from.
gt;
gt; Is there a way of doing this without having to set up the Pivot table again.
gt;
gt; Thank you
gt; --
gt; pk

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

www.contextures.com/xlPivot01.html

PK wrote:
gt; I have created a pivot table to extract iformation from a data base. I have
gt; now added to the data base therfore I need to expand the renge for the table
gt; to read from.
gt;
gt; Is there a way of doing this without having to set up the Pivot table again.
gt;
gt; Thank you--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html