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
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