Dynamic Pivot tables

Is it possible to have a pivot table that automatically takes into account
any new rows that are added to the base table?

MTIA

Phil

Try Debra's page at:

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

Scroll down a bit, look for: Use a dynamic data source

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

"Phil" wrote:

> Is it possible to have a pivot table that automatically takes into account
> any new rows that are added to the base table?
>
> MTIA
>
> Phil

Hi Phil

note, even using the method outlined at Debra's site you still need to press
the REFRESH button to update the pivot table.

Cheers
JulieD

"Max" <[email protected]> wrote in message
news:[email protected]...
> Try Debra's page at:
>
> http://www.contextures.com/xlPivot01.html
>
> Scroll down a bit, look for: Use a dynamic data source
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
> "Phil" wrote:
>
>> Is it possible to have a pivot table that automatically takes into
>> account
>> any new rows that are added to the base table?
>>
>> MTIA
>>
>> Phil

Thanks to both of you for your help!!

Its working fine

Phil

"JulieD" wrote:

> Hi Phil
>
> note, even using the method outlined at Debra's site you still need to press
> the REFRESH button to update the pivot table.
>
> Cheers
> JulieD
>
> "Max" <[email protected]> wrote in message
> news:[email protected]...
> > Try Debra's page at:
> >
> > http://www.contextures.com/xlPivot01.html
> >
> > Scroll down a bit, look for: Use a dynamic data source
> >
> > --
> > Rgds
> > Max
> > xl 97
> > ---
> > GMT+8, 1° 22' N 103° 45' E
> > xdemechanik <at>yahoo<dot>com
> > ----
> >
> > "Phil" wrote:
> >
> >> Is it possible to have a pivot table that automatically takes into
> >> account
> >> any new rows that are added to the base table?
> >>
> >> MTIA
> >>
> >> Phil
>
>
>