CELL RANGE SELECTION ON EXISTING PIVOT TABLE

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

MitchP wrote:
>
> 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

Dave:

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

"Dave Peterson" wrote:

> 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
>
> MitchP wrote:
> >
> > 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
>

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.

MitchP wrote:
>
> Dave:
>
> Sorry to sound like a dope. Don't understand "hit the back a few times".
> Please clarify. Thanks, Mitch P
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > MitchP wrote:
> > >
> > > 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
> >

--

Dave Peterson

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.

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

MitchP wrote:
>
> 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

Dave:

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

"Dave Peterson" wrote:

> 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
>
> MitchP wrote:
> >
> > 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
>

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.

MitchP wrote:
>
> Dave:
>
> Sorry to sound like a dope. Don't understand "hit the back a few times".
> Please clarify. Thanks, Mitch P
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > MitchP wrote:
> > >
> > > 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
> >

--

Dave Peterson