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.