I have a worksheet with approximately 20,000 rows. I have an existing pivot table that is built on this data. I would like to build another pivot table on the SAME data, but don't want re-build the pivot from scratch...and I don't want to drastically increase the size of the file (i.e. "copy")
.

I remeber in Excel 2003 there was a pivot table option to choose "another pivot table report". Does this functionality exist in v2007?

Thanks, Dan