Hi

Is there a way of ammending a drill down of a pivot table, then using it to
update the original table.

Thanks.

You'd need to change the pivot table's data source to the drilldown range,
by selecting some part of the table and then starting the pivot table
wizard.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"nc" wrote in message
...
Hi

Is there a way of ammending a drill down of a pivot table, then using it
to
update the original table.

Thanks.