how to create a new pivot table based on another pivot table inc. filters/slices etc

[domlep]

Hi,

I have a master sheet which houses a dynamic pivot chart/graph along with various filters and slicers.

Once I have applied the relavent filters and slicers to the pivot - I want to be able to "copy" this pivot table/chart to a separate sheet - using a separate datacache - but preserving all of the filters/slicer settings that were applied to the original graph.

I can't find a way to unlink the two pivot caches whilst keeping the exact filter settings in place

thanks for any help you can give