Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA used with a central pivot table - values vanish
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a range of values on pivot table attribute with a macro | Excel Discussion (Misc queries) | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Using Pivot Table Values | Excel Discussion (Misc queries) | |||
how to remove old selection values in the pivot table | Excel Discussion (Misc queries) |