I recently found a great PowerPivot feature to make the published PowerPivot sheet “view only” for a end user.
When you have write permissions for a PowerPivot sheet you can open the sheet in Excel and use all the measures and columns and use everything available in the sheet by using the “Open in Excel” button:
Now the great news, you can contain these permission to view only, documents can only be viewed sever side:
When you open the PowerPivot sheet in the browser you see the Open in Excel button is gone:
When we open the PowerPivot gallery as a default document library you will not be able to download the Excel sheet, it will render as html when you download it. I think this will be a very usefull permission !