Hello,
Before power pivot, I was able to protect my sheets to avoid refresh of pivot tables.
But now I have created a POWER VIEW sheet, seems it is not possible to avoid the right click refresh in the power view sheet...
I know that in term of publish and use, I would use the sharepoint and PowerPivots capabilities, but, it is not allowed in our company.
So I want to use power pivot in the Excel client, but with a minimum of security, and avoid that user try to refresh the datamodel from powerview sheet.
Seems it is not possible
Do you have any experience on this ?
Thank you.
Before power pivot, I was able to protect my sheets to avoid refresh of pivot tables.
But now I have created a POWER VIEW sheet, seems it is not possible to avoid the right click refresh in the power view sheet...
I know that in term of publish and use, I would use the sharepoint and PowerPivots capabilities, but, it is not allowed in our company.
So I want to use power pivot in the Excel client, but with a minimum of security, and avoid that user try to refresh the datamodel from powerview sheet.
Seems it is not possible
Do you have any experience on this ?
Thank you.
Last edited: