pivot table template

[Newbie]

Hi,

I currently have a template linked to various other books. There are many
links and not always reliable due to row insertion etc.
I would prefer to consolidate into a pivot table, with different vies for
the diffent data I require.
Is it possible to link a template to data a pivot table queries rather than
the cells within a pivot table?

 

[Debra Dalgleish]

You can use the GetPivotData function to extract data from a pivot
table. There are instructions in Excel's help, and here:

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