Timeline Slicer Not working

[Balajisx]

Dear Experts,

I have an excel dashboard with Slicers and Timeline slicer. I have protected the sheet and and I have unlocked the Slicer and Timeline slicer from protection. However I am not able to select the month/year/days trend from the drop down. Could you please help me to fix this issue ?

Thank you for your support!!

 

[Hui]

Balajisx

Firstly, Welcome to the Chandoo.org Forums

I'd try allowing one or more of these 3 options

I'm not sure exactly which one is causing the issue but try PivotTables first
The Slicer maybe an Object

 

[Balajisx]

Hello !!
Thank you for your reply. I tried by selecting all the option which is shown above. However the drop-down selection is not working for selecting the yearly and quarterly trend. Is there any way to unlock them?

 

[NARAYANK991]

Hi ,

Uploading a workbook always gets you an answer much faster.

Narayan

 

[Balajisx]

Hi Narayanan.. I will not be able to upload or download files from external source's. Since it is against my company policy..

 

[Balajisx]

I have taken a snap shot about my question to give you a better clarity. Please advise.