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 <atyahoo<dotcom
----

"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" wrote in message
...
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 <atyahoo<dotcom
----

"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" wrote in message
...
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 <atyahoo<dotcom
----

"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