View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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