two pivot q's - get rid og getpivotdata and pivot based on pivot

[Light]

Hi,

I've been so lucky as to get new excel and am stuggling with two things I
can't do anymore.

1. Remove getpivotdata - if I click in cell B5 I want the formula to use B5
and not lock to a particular cell.

2. Base second, third, etc pivot tables on a first. There's a box for this
now, but I've no idea how to use it anymore.

I'd really appreciate it if anyone knows how to do these things.
Thanks, Light.

 

[Jon Peltier]

Debra Dalgleish shows how to remove that annoying GetPivotData feature here:

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

- Jon