Pivot Timeline Slicer does not work when sheet locked (changing Days/Months/Quarters/Years)

Copper Contributor

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.

2 Replies

Hi @MikiP

 

Currently not possible as far as I know sorry

 

There's a UserVoice request here to vote to enable this 

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10765209...