Thread: cancelling getpivot formula when setting formula outside pivot ta.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default cancelling getpivot formula when setting formula outside pivot ta.
See Debra Dalgleish's website for GetPivotData instructions:

http://www.contextures.com/xlPivot06.html#GetPivotData

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"cancelling getpivot formula" wrote:

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?
Reply With QuoteReply With Quote