| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GetPivotData for hidden fields
Is there a way to retrieve data from a PivotTable if the data isn't currently
visible? I can use GetPivotData, but when the table fileds are re-arranged, the GetPivotData formula fails because the fields aren't currently visible. Any way around this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GETPIVOTDATA Bug | Excel Worksheet Functions | |||
| Pivot table # of fields | Excel Discussion (Misc queries) | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
| Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Threaded Mode
