Sep 23 2019 07:33 AM
I've inserted a linked Timeline Slicer and it works perfectly, except when I lock the sheet, I can still select whatever Months desired, but cannot change the dropdown to Days/Months/Quarters/Years.
I do have the slicer NOT locked and when lock sheet I allow User PivotTable & PivotChart which allows all other slicers to function properly and this one just for whichever timeframe I have on before lock.
Sep 24 2019 03:00 AM
Hi @MikiP
Currently not possible as far as I know sorry
There's a UserVoice request here to vote to enable this
Sep 24 2019 06:09 AM
thank you I will definitely vote!