Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am wondering if it is possible to prevent exporting data to excel on one sheet or one object without preventing it on the entire document. I have some sensitive data on one sheet that I don't want users to export, but on the other sheets I want to allow the users to export to excel.
Can you uncheck the 'send to excel' box under caption tab of that chart?
i dont get it, if it's sensitive, and you are displaying, they can still do a screen shot?
Disable the caption, the user can still right-click and send to excel i think.
Perhaps, you can go to Sheet Properties > Security > check the box for Read Only.
But still.. doesnt make sense...
or
I did uncheck the box on the caption box, but you can still right click and send to excel is still an option.
If I unselect Export to Excel in document properties it applies to all sheets in the document even if my other sheets have the send to excel box checked in the caption.
I tried the read only option and it still allows you to right click and send to excel.