I would like to share an excel file that has slicers and charts in it. I want users to be able to use the slicers for filtering and then select and copy the charts. But I want to protect the sheet and prevent any editing of the chart and the slicers.
As far as I can see, the options are to lock the charts and slicers, in which case they are uneditable when the sheet is protected, but then the slicers are frosen and the chart can't be copied (PrintScreen is not an option). OR, to unlock them, in which case they become usable but editable.
Is there a way around this?
برچسب:
نویسنده: استخدام کار