| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
adding rows to pivot table
I have a pivot table that refers to a 7000 row "rawdata" workbook (A1:E7000) I just appended another 7000 rows of new data to that workbook (so now it is A1:E14000). However, my pivot table does not seem to be including the new rows. How do I update the pivot table to expand itself to include those new 7000 rows? -- cwinters ------------------------------------------------------------------------ cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386 View this thread: http://www.excelforum.com/showthread...hreadid=376800 |
|
#2
|
|||
|
|||
|
- right click the pivot table
- select Pivot table wizard - select "Back" - change (expand) the data source range to include your new data - click "finish" -- George Nicholson Remove 'Junk' from return address. "cwinters" wrote in message ... I have a pivot table that refers to a 7000 row "rawdata" workbook (A1:E7000) I just appended another 7000 rows of new data to that workbook (so now it is A1:E14000). However, my pivot table does not seem to be including the new rows. How do I update the pivot table to expand itself to include those new 7000 rows? -- cwinters ------------------------------------------------------------------------ cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386 View this thread: http://www.excelforum.com/showthread...hreadid=376800 |
|
#3
|
|||
|
|||
|
I'd use a dynamic range name that could expand and contract based on the number
of used cells in one of the data columns. (do you have a column that's always filled???) Take a look at Debra Dalgleish's site: http://www.contextures.com/xlNames01.html#Dynamic cwinters wrote: I have a pivot table that refers to a 7000 row "rawdata" workbook (A1:E7000) I just appended another 7000 rows of new data to that workbook (so now it is A1:E14000). However, my pivot table does not seem to be including the new rows. How do I update the pivot table to expand itself to include those new 7000 rows? -- cwinters ------------------------------------------------------------------------ cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386 View this thread: http://www.excelforum.com/showthread...hreadid=376800 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
