PivotTable Slicer issue on copying the worksheet to a new workbook

[Collie]

Hello all
My current task is to create some pivot tables of somewhat sensitive data for different users. Each end user should not be able to view what information belongs to another user. Using two separate columns requiring 'Slicers' are able to give me the correct output required. The slicers applying to the pivot table have been put on a different sheet, so are not end-user interactive. The method I was trying to implement was to set the slicers, copy the resultant pivottable worksheet to a new workbook and email it to the end user.

However, I have found that upon copying the worksheet to a new workbook, only one of the two slicers still applies, while the other one seems to not work. The result is more data than should be is shown in the copied worksheet.

Any assistance would be greatly appreciated.

Thanks
Collie

 

[Collie]

Hopefully to help - I have snipped my source worksheet and copied worksheet. the ws on the left shows the two slicers working correctly, and the ws on the right shows the result after copying. The slicer for the produce type is still working, however, the slicer over 'shop' is no longer operative.