Forum Discussion
How to protect graphs/charts in Excel online
Hi, I have created a pivot table chart with slicers in Excel desktop, and I’ve protected them both so users can only interact with the slicers. In the desktop version, after I protect the sheet then ...
As far as I know in Excel Online, you may not have direct options to protect slicers and charts as you do in the desktop version.
Try placing your charts and slicers in a separate sheet and protect that sheet. Users can interact with slicers and view charts, but they can't move them.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Try placing your charts and slicers in a separate sheet and protect that sheet. Users can interact with slicers and view charts, but they can't move them.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
I haven't had time to try it yet, but when I do, I'll reply. I just want to thank you for replying!
