| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I export multiple lines of data from a pivot table?
Excel 2007 PivotTable
The automatically generated GetPivotData() formula refers to only one PT cell and its references are not incremented when you drag the cell down. Edit the formula for use in an external array this way: http://www.mediafire.com/file/mt3dmm...03_17_09a.xlsm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export Pivot Table Data to Excel Table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| how do I create Excel pivot table with over 65,535 lines of data? | Excel Discussion (Misc queries) | |||
| Display Row label covering multiple lines in Excel Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
