CELL RANGE SELECTION ON EXISTING PIVOT TABLE

[Guest]

HELLO AGAIN:
i NEED TO ADD MORE DATA TO AN EXISTING PIVOT TABLE, BUT DO NOT KNOW HOW TO
SELECT A NEW CELL RANGE IN EXCEL 2003.

 

[Dave Peterson]

You'd have to rightclick on the pivottable and hit the back a few times to reset
the range.

But even better would be to use a dynamic range that grows and contracts when
you add/delete rows.

http://www.contextures.com/xlNames01.html#Dynamic

 

[Guest]

Dave:

Sorry to sound like a dope. Don't understand "hit the back a few times".
Please clarify. Thanks, Mitch P

 

[Dave Peterson]

Oops. I left out an important step.

Right click on the pivottable, choose Wizard and then hit the back a few times
to get to step where you specify the range.