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

  • Thread starter Thread starter Light
  • Start date Start date
L

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.
 
Back
Top