| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 formula for Pivot
When I use the formula referencing the pivot table in Excel 2003 instead of
just showing the cell reference it shows the GETPIVOTDATA. How to get just the cell reference always by default? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2003 formula for Pivot
Debra Dalgleish shares a way:
http://contextures.com/xlfaqPivot.html#GetPivotData Rama Chandra wrote: When I use the formula referencing the pivot table in Excel 2003 instead of just showing the cell reference it shows the GETPIVOTDATA. How to get just the cell reference always by default? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Pivot Table | Excel Discussion (Misc queries) | |||
| Edit Formula in Pivot Table for 2003 and 2007-how? | Excel Discussion (Misc queries) | |||
| 2007 pivot tables in 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 view formula within pivot table | Excel Worksheet Functions | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Linear Mode
