Hi.
Hoping I can get some help please with regards to a pivot table with slicers.
I have created a pivot in a spreadsheet with slicers which works perfectly (sheet1). However this is a shared spreadsheet and I would like the second user to use a copy of this pivot table but in the same spreadsheet, separate sheet (sheet2)
I copied the sheet and then put on new slicers but every time I user the slicers in sheet1 , it affects sheet2 - visa versa. I am sure there is a simple solution. I didn't want to recreate the pivot but if this is the case then I will have to do this. I also want the data to be kept in the same document.
The data is reading from data in power query too.,
Many thanks for the assistance
Jacc14
Bookmarks