GETPIVOTDATA used with a central pivot table - values vanish

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report template that uses getpivotdata from pivot tables hidden in
the background. There are many templates in use and refreshing each one was
becoming very time consuming. I hoped to use one central set of pivot tables
and point all of the indivual reports to this workbook using getpivotdata. I
discovered that the data vanishes unless the central "pivot sheet" is open.
Is there any easy way around this? Many thanks in advance for your
willingness to share your acumen.
 
Thanks Jim. The pivot tables that I use are pulling data from Access
queries. The queries pull from linked tables (ODBC to SQL). I am unable to
guarantee that the field in "column C" will remain there (e.g. the data is
very dynamic). Will this approach fit into that model? I also need to pull
back the total number of records that satisfy 3+ criteria... I am not very
familiar with sumproduct, so I want to be sure that this method will ring the
bell. Thanks very much for your guidance.
 

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

Getpivotdata references have stopped loading pivot-refreshed value 1
Pivot table column help 2
Consolidate information from multiple pivot tables 2
Pivot Table Refresh option not able to see 1
How do I use a pivot table value to reference a worksheet 10
Pivot table not recognizing same field values 1
Pivot table not recognizing same field values 1
Referencing Data in a Pivot table. More Excel 2003 misery 1

Back
Top