PivotTable Data

[Laura]

Hi--I'm using a simple worksheet as the source for my
Pivot Table. Question: Is there a macro or something I
can run that will automatically detect when I've *added*
lines and include them in the data set? Or am I
relegated to continually using the wizard to re-select
the data set to include the new data?? THANK YOU!!!!
This has been driving me nuts!

 

[Debra Dalgleish]

You can base the pivot table on a dynamic range, which will
automatically expand to include new items. There are instructions here:

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

Then, when you refresh the pivottable, the new data will be included.

 

[Ed Ferrero]

Hi Laura,

You can use a dynamic range as the data range for a pivot table.
Go to http://edferrero.m6.net/DataTutor1.html for instructions
on how to do this.

Ed Ferrero

 

[Laura]

Fabulous, thank you!!!!! So much better!

-----Original Message-----
You can base the pivot table on a dynamic range, which will
automatically expand to include new items. There are instructions here:

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

Then, when you refresh the pivottable, the new data will be included.




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

.

 

[Laura]

Fabulous, thank you!!!!

-----Original Message-----
Hi Laura,

You can use a dynamic range as the data range for a pivot table.
Go to http://edferrero.m6.net/DataTutor1.html for instructions
on how to do this.

Ed Ferrero




.