How to copy and paste a pivot table (with slicer) to a new workbook, ommitting data source

I created a pivot table using proprietary data and also added in a slicer. The data was exported from software at work and plugged into a macro (which I did not write).

My goal is to give the pivot table to a client in the form of a new workbook, but they can only see the pivot table with its slicer, not the original data source or the macro code.

Is this possible?

Save your original workbook as copy but with xlsx extension it will remove any vba code
Change source of PivotTable in this copy to dummy data

not enough information to say something more

Originally Posted by sandy666

Save your original workbook as copy but with xlsx extension it will remove any vba code
Change source of PivotTable in this copy to dummy data

not enough information to say something more

How do I convert all of the data to dummy data?

mybe find&replace?

I don't know structure and kind of the data in your excel file