CELL RANGE SELECTION ON EXISTING PIVOT TABLE
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 |
All times are GMT +1. The time now is 03:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com