Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table range issues from report writer download | Excel Discussion (Misc queries) | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) |