ExcelBanter - 2003 formula for Pivot

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 2003 formula for Pivot (https://www.excelbanter.com/excel-discussion-misc-queries/244792-2003-formula-pivot.html)

Rama Chandra

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?

Dave Peterson

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

All times are GMT +1. The time now is 09:01 AM.