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?