View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cancelling getpivot formula cancelling getpivot formula is offline
external usenet poster
 
Posts: 1
Default cancelling getpivot formula when setting formula outside pivot ta.

In the office 2003 version an automatic getpivotdata formula is created when
setting a formula outside the pivot table.this makes it impossible to copy
the formula to other cells as all data becomes fixed.
how can I turn to my old formula setting mode?