Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-870386%22%20slang%3D%22en-US%22%3EPivot%20Timeline%20Slicer%20does%20not%20work%20when%20sheet%20locked%20(changing%20Days%2FMonths%2FQuarters%2FYears)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870386%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20inserted%20a%20linked%20Timeline%20Slicer%20and%20it%20works%20perfectly%2C%20except%20when%20I%20lock%20the%20sheet%2C%20I%20can%20still%20select%20whatever%20Months%20desired%2C%20but%20cannot%20change%20the%20dropdown%20to%20Days%2FMonths%2FQuarters%2FYears.%20%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20have%20the%20slicer%20NOT%20locked%20and%20when%20lock%20sheet%20I%20allow%20User%20PivotTable%20%26amp%3B%20PivotChart%20which%20allows%20all%20other%20slicers%20to%20function%20properly%20and%20this%20one%20just%20for%20whichever%20timeframe%20I%20have%20on%20before%20lock.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871730%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Timeline%20Slicer%20does%20not%20work%20when%20sheet%20locked%20(changing%20Days%2FMonths%2FQuarters%2FYears)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871730%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409724%22%20target%3D%22_blank%22%3E%40MikiP%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECurrently%20not%20possible%20as%20far%20as%20I%20know%20sorry%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere's%20a%20UserVoice%20request%20here%20to%20vote%20to%20enable%20this%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10765209-enable-the-time-level-functionality-of-the-timelin%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10765209-enable-the-time-level-functionality-of-the-timelin%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-872045%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Timeline%20Slicer%20does%20not%20work%20when%20sheet%20locked%20(changing%20Days%2FMonths%2FQuarters%2FYears)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872045%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%20I%20will%20definitely%20vote!%3C%2FP%3E%3C%2FLINGO-BODY%3E
MikiP
New 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...

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies