How to ensure slicer works even when the source data tab is locked?

[Diwakar]

I have developed a dashboard using excel sheet. I have my source/raw data in one of the sheets. Then I have the pivot tables in another sheet. And finally, have my dashboard in a separate sheet. I have slicers in my dashboard to filter as per my preference. Now when I lock the sheets in which I have my source data, the filter or the slicer in the dashboard is not working. How do I resolve this?

 

[Johnhtvu]

When you protect the dashboard sheet (where the slicers are) - you have to make sure you check the box "edit objects".

your filters should work now. please let me know if that works.

 

[Diwakar]

When you protect the dashboard sheet (where the slicers are) - you have to make sure you check the box "edit objects".

your filters should work now. please let me know if that works.

Thank you so much. That worked