Sharing Powerpivot reports

Question

I have generated a report in Powerpivot for excel and want to share it with other members of my team. I do not want all of them to download and install Powerpivot add-on.

I found out that the report can be shared over SharePoint 2010. For this I need to get the Powerpivot add-on for SharePoint installed as part of SQL Server. Am I right or Is there any way I can get Powerpivot to work with SharePoint? Buying SQL server just for Powerpivot add-on is not worth it because we will not be using SQL server. Is there any other way in which I can share the report?

Answer 1

Hi,

YOu have two options in PowerPivot:

PowerPivot for Excel and PowerPivot for SharePoint, as you said, PowerPivot for SharePoint is inside SQL Server installer, then you need SQL Server for integrate PowerPivot with SharePoint.

WIth Excel Services you can share some type of Reports, but those reports will not be PowerPivot oriented.

Regards!

---

---

José Quinto Zamora
SharePoint and Search Specialist at SolidQ(http://www.solidq.com)
MCITP and MCPD in SharePoint 2010
http://blogs.solidq.com/sharepoint

Answer 2

Hi Jose,

Thanks for the reply.

It does not make sense for us to buy SQL server just for using powerpivot with sharepoint. We wish at least powerpivot for sharepoint was licensed separately.

I assume even using a trial version of SQL server to install powerpivot would not work after 180 days. Is this right?

Regards.

Answer 3

You can't use trial version after trial period is over. I don't think there is a seperate licence for ' power pivot for share point'.It will come with SQL Server.

check this link

http://social.technet.microsoft.com/Forums/hu/sharepoint2010setup/thread/4145f524-a710-4b67-9bf3-8071d6660c79

=====================

Please mark as answer if this answers your question.