Z zezo2021 Member Local time Today, 12:30 Joined Mar 25, 2021 Messages 412 Feb 21, 2022 #1 I have 5 ranges in excel from 5 sheets I built 5 pivot on these 5 ranges the 5 ranges have a shared column (Status) I use slicer based on pivot table for every range my question can I use one slicer for All pivot tables
I have 5 ranges in excel from 5 sheets I built 5 pivot on these 5 ranges the 5 ranges have a shared column (Status) I use slicer based on pivot table for every range my question can I use one slicer for All pivot tables
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 18:30 Joined May 7, 2009 Messages 20,325 Feb 22, 2022 #3 see the technique here: Update Excel Slicers with Macro (contextures.com)