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

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.

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

Debra Dalgleish shows how to remove that annoying GetPivotData feature he

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Light wrote:
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.