How to enable slicers on a locked worksheet - Excel 2010

No replies
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 08/16/2010
Posts: 1

hi there

I'm frustrated! I cant seem to enable the slicers on a locked worksheet in Excel 2010. I need to be able to protect the sheet so users cant change the pivot table structure but they still need to be able to manipulate the slicers and view the data

thanks!