| 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? |
| 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) | |||
Threaded Mode
