Hi all,
I have an annoying problem which I now see for the first time.
I have a sheet as template, with 2 pivot tables and 2 slicers. I copy this sheet a few times and per sheet select with the slicer the data I wish to see.
Last year when I built this report, I had no issues, however now when I copy the sheet, all sliders keep connecting to 1 sheet.
In “report connections” I have disconnected all other sheets so the slicers only connect to the sheet the slicer is located on, but somehow all other sheets are then again linked to that 1 slicer.
I have already removed the slicers to disconnect everything, but that does not work. Does anyone know how to fix this issue?
Bookmarks