Is there any way to lock a slicer from un-filtering?
Example: I have 7 charts all linked to different slicers but with one of the slicers i only want to show 2 of the 3 options at all times. even when un-filtering. is there a way to do this?
Is there any way to lock a slicer from un-filtering?
Example: I have 7 charts all linked to different slicers but with one of the slicers i only want to show 2 of the 3 options at all times. even when un-filtering. is there a way to do this?
Maybe have a vba to auto filter my 2 options everytime the the filters are cleared?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks