Make your PowerPivot on SharePoint “view only”
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:
Tags: sharepoint, tip, excel