PivotTable Data

Laura · Jun 23, 2004

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 · Jun 23, 2004

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 · Jun 23, 2004

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 · Jun 23, 2004

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 · Jun 23, 2004

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

.