cancelling getpivot formula when setting formula outside pivot ta.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cancelling getpivot formula - 31 Oct 2006 16:41 GMT

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 to this Message

Ron Coderre - 31 Oct 2006 17:05 GMT

See Debra Dalgleish's website for GetPivotData instructions:

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

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

XL2002, WinXP

> 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 to this Message

Pé - 31 Oct 2006 23:31 GMT

In stead of selecting the cell by clicking the button of your mouse to use in
your formule, you have to type the cell number in your formula (example type
=a2-b2 in stead of clicking on cell a2 & than on b2 with your mouse).

Normally this should do it.

> See Debra Dalgleish's website for GetPivotData instructions:
>
[quoted text clipped - 11 lines]
> > the formula to other cells as all data becomes fixed.
> > how can I turn to my old formula setting mode?

Reply to this Message