how do i avoid a formula in excel2003 automatically using getpivot
 

if i try to enter a simple formula using a cell within a pivot table excel
2003 automatically uses the getpivotdata function. This is not always
required and did not happen in 2000. Any way to avoid this ?

how do i avoid a formula in excel2003 automatically using getpivot
 

Check Debra Dalgleish's site:
http://contextures.com/xlPivot06.html#GetPivotData

Peterhine21 wrote:

if i try to enter a simple formula using a cell within a pivot table excel
2003 automatically uses the getpivotdata function. This is not always
required and did not happen in 2000. Any way to avoid this ?

--

Dave Peterson