Pivot table how to check data source ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Piotr - 29 Dec 2005 07:42 GMT

Hi I have many pivot tables in one file, as I have to refresh every of
them I need to check if the pivot table source is from other pivot
table in my file, so I need to refresh only the main pivot table, or if
data is from database so I have to refresh this particular pivot table.

regards
Peter

Reply to this Message

Debra Dalgleish - 29 Dec 2005 15:14 GMT

There's information here:

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

that will help you determine which pivot cache each pivot table uses.

> Hi I have many pivot tables in one file, as I have to refresh every of
> them I need to check if the pivot table source is from other pivot
[quoted text clipped - 3 lines]
> regards
> Peter

Signature

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

Reply to this Message