| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy GetPivotData Outside Report
I create the getpivotdata outside the report and when I copy the formula, the
cell reference in the getpivotdata function is not relative. How do I copy the getpivotdata function with the relative cell reference? -- Thank you... Elaine |
|
#2
|
|||
|
|||
|
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html Elaine wrote: I create the getpivotdata outside the report and when I copy the formula, the cell reference in the getpivotdata function is not relative. How do I copy the getpivotdata function with the relative cell reference? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Debra,
Thank you for your quick reply to my question. Elaine "Debra Dalgleish" wrote: There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html Elaine wrote: I create the getpivotdata outside the report and when I copy the formula, the cell reference in the getpivotdata function is not relative. How do I copy the getpivotdata function with the relative cell reference? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
Debra,
When I create the GetPivotData function with the Generate GetPivotData feature turned on and I trend the function it does not update the cell reference from the PivotTable Report. What am I doing wrong? Thank you again for your help. Elaine "Debra Dalgleish" wrote: There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html Elaine wrote: I create the getpivotdata outside the report and when I copy the formula, the cell reference in the getpivotdata function is not relative. How do I copy the getpivotdata function with the relative cell reference? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a push report in Excel? | Excel Discussion (Misc queries) | |||
| Copy Function | Excel Discussion (Misc queries) | |||
| Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
| Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| report manager excel | Excel Discussion (Misc queries) | |||
Linear Mode
