If you want to share and publish the PowerPivot workbook to Sharepoint server and view the workbook from Sharepoint, you will need to install the middle tier Analysis Services component from SQL Server 2008 R2.
Should you need additional information, please visit the official web site for PowerPivot
http://powerpivot.com/.
Thanks!
Lisa