Linking Data from Pivot Table

L

Lone

I have 10 pivot tables with monthly data and I need to create a separate
sheet with the work book to display a summary.

In the summary sheet I have to show a row of the monthly data from each of
the 10 different tables. I tried doing this by "paste link" however each
time the pivot tables are refreshed the new data will not be updated to my
summary sheet.

What function should I use?
 
R

Roger Govier

Hi

Because the position of the row of data you require from each PT may vary,
each time a PT is refreshed, you need to use the GetPivotData function, to
return the value for each PT.

For more help on this take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically sending multiple parts of text from one word doc to another - is possible. 0
Dealing with a Pivot Table (when I don't want to) 0
Dumb question alert! What program to use? 0
Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Link a file to a Pivot Table in another file 0
Consolidation Table from Different Excel Tabs with Different Format 1
Power Pivot. Yikes. 0

Top