Pivot table, dynamic data formula

[Guest]

I set up a dynamic formula as noted on the Contextures website
<http://www.contextures.com/xlPivot01.html#Dynamic> . I have multiple pivot
tables in my worksheet. I would like to set up the pivot tables so they
refer to the 1st pivot table, which references the dynamic formula range. In
the pivot table wizard,when I change the data source for each of the pivot
tables to the 1st pivot table, click "finish" and go back into the wizard to
see what data the table is referring to, it always comes up with the dynamic
formula, not the 1st pivot table.

I believe the drawback is that you have to refresh each pivot table
individually. Is there anyway around the issue? We are rolling out a sales
reporting tool and believe the salespeople will get confused if they have to
refresh the query and every single pivot table(there are many). Is there a
way to refresh multiple pivot tables with one click?

 

[Debra Dalgleish]

If the pivot tables are based on the same pivot cache, when you refresh
one, all will be refreshed. To base a new pivot table on an existing on,
choose 'Another PivotTable Report or PivotChart Report' in step1 of the
pivottable wizard.

To determine which pivot cache was used for each pivot table, you can
use a User Defined Functions, as described here:

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

 

[Guest]

Debra, eventually, I will just go to your site when I need help. I don't
always match the solution I need to the descriptions on your site, but
quickly after I post an item I'm directed to your site again.

I think I've used almost every topic you've posted on pivot tables. Thank
you so much.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that the information on my
site has helped you.