| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
create pivot table formula without the GETPIVOTDATA function
Previous to Excel 2003 I could use a pivot table result in a formula and copy
that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula is created and uses an absolute reference. Is there a way in Excel 2003 to either make it arelative reference (without editing the formula) or revert to the method used in all prior releases? |
|
#2
|
|||
|
|||
|
create pivot table formula without the GETPIVOTDATA function
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 ebergkes wrote: Previous to Excel 2003 I could use a pivot table result in a formula and copy that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula is created and uses an absolute reference. Is there a way in Excel 2003 to either make it arelative reference (without editing the formula) or revert to the method used in all prior releases? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
create pivot table formula without the GETPIVOTDATA function
After posting I saw reference to your site and found the answer there - great
site. Thank you! "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 ebergkes wrote: Previous to Excel 2003 I could use a pivot table result in a formula and copy that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula is created and uses an absolute reference. Is there a way in Excel 2003 to either make it arelative reference (without editing the formula) or revert to the method used in all prior releases? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
create pivot table formula without the GETPIVOTDATA function
You're welcome!
ebergkes wrote: After posting I saw reference to your site and found the answer there - great site. Thank you! "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 ebergkes wrote: Previous to Excel 2003 I could use a pivot table result in a formula and copy that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula is created and uses an absolute reference. Is there a way in Excel 2003 to either make it arelative reference (without editing the formula) or revert to the method used in all prior releases? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- 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 pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| Get Pivot Table Data Formula | Excel Discussion (Misc queries) | |||
| How do I create a pivot table from multiple pages of data? | Excel Worksheet Functions | |||
| count function in pivot table | Excel Discussion (Misc queries) | |||
| Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Hybrid Mode
