pivot table with dynamic base data
 

hiya,

im trying to create a pivot table where I can change my base data (inserting
or deleting rows of data) and still have this reflected in the pivot table.

My solution was to use entire columns as my range for input to the
pivotTable, but this means including blank rows which seems to muck up the
calculations.
I cant think how else i can allow for new rows to be added to the base data
anyone got any ideas how to do this?

thanks loads for your help!

You can use a dynamic range as the source. There are instructions he

http://www.contextures.com/xlPivot01.html

bb wrote:
hiya,

im trying to create a pivot table where I can change my base data (inserting
or deleting rows of data) and still have this reflected in the pivot table.

My solution was to use entire columns as my range for input to the
pivotTable, but this means including blank rows which seems to muck up the
calculations.
I cant think how else i can allow for new rows to be added to the base data
anyone got any ideas how to do this?

thanks loads for your help!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

thankyou, works perfectly!

"Debra Dalgleish" wrote:

You can use a dynamic range as the source. There are instructions he

http://www.contextures.com/xlPivot01.html

bb wrote:
hiya,

im trying to create a pivot table where I can change my base data (inserting
or deleting rows of data) and still have this reflected in the pivot table.

My solution was to use entire columns as my range for input to the
pivotTable, but this means including blank rows which seems to muck up the
calculations.
I cant think how else i can allow for new rows to be added to the base data
anyone got any ideas how to do this?

thanks loads for your help!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html