GETPIVOTDATA used with a central pivot table - values vanish

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.
 
G

Guest

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

Error when Formula references a pivot table in an external workboo 2
No. of columns in a Pivot Table 1
slow document / pivot table refresh and pivot function 2
Copy a calculated field from a pivot table 1
Pivot Table combine rows with matching ID and SUM amounts 3
update pivot fields VBA 1
Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument" 1
Fill a Listbox with Values from a Pivot Table Field - an Example 0

Top