Maybe you could have a macro that copies your pivottable to another location,
then converts to values, then fills in the cells.

Lots of my pivottables are only pivottables for a bit--just waiting to be
converted to values.



km wrote:

repeating information is hiden on a pivot table, I would like the ability to
see a summation of this data without having to copy the pivot table as a
value & filling in the repeating data.

* you loose the functionality of the pivot table
* it becomes very time consuming with large pivot tables

current view:

Order ID Product Total
10248 Mozzarella di Giovanni 5
Queso Cabrales 12
Singaporean Hokkien Fried Mee 10

would like ablitity to view:

Order ID Product Total
10248 Mozzarella di Giovanni 5
10248 Queso Cabrales 12
10248 Singaporean Hokkien Fried Mee 10

--

Dave Peterson