Can we use PowerPivot without SharePoint?

Question

Hello,

      Can we use PowerPivot of SQL Server 2008 R2 without SharePoint? If yes please explain in brief or reffer any resources regarding the topic.

Thanks in advance.

Nilkanth S. Desai

Answer 1

You can use PowerPivot add-in in excel without SharePoint. But if you would like to collaborate on PowerPivot workbooks in SharePoint, or use PowerPivot as a data source for PowerView, you simply have to use SharePoint Enterprise.

http://www.microsoft.com/en-us/download/details.aspx?id=29074

---

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

Answer 2

Hi Nilkanth,

You can't use PowerPivot of SQL Server 2008 R2 without SharePoint. PowerPivot for SharePoint provides centralized data access to PowerPivot workbooks in a SharePoint environment. A complete deployment of PowerPivot for SharePoint includes client and server components that integrate with Excel and Excel Services in a SharePoint farm.

1. PowerPivot of SQL Server 2008 R2 for SharePoint is the server component and the server component (PowerPivot for SharePoint) requires both SQL Server 2008 R2 and SharePoint 2010. To enable sharing and collaboration on PowerPivot for Excel applications and models, you must install SQL Server 2008 R2 as part of the SharePoint farm. [Ref: http://msdn.microsoft.com/en-us/library/ee210692.aspx]
2. PowerPivot for Excel is an add-in to Excel 2010 that is used for adding and integrating large amounts of data in Excel workbooks. PowerPivot for Excel client is the client component and it does not require anything else besides a simple installer and does not required SQL Server 2008 R2 running in your local machine. The client component is a standalone Excel 2010 add-in that can query any data source, including SQL Server.[Ref: http://msdn.microsoft.com/en-us/library/ee210644]
3. PowerPivot for Excel doesn't depend on SharePoint 2010 and the only client dependency is Excel 2010. It will not work with earlier versions of Excel.

Hope the points will clear your doubt.

Thanks!!

Regards,

Vijay Kumar (MCTS)
[Kindly Mark As Answer if my post solves your problem or Vote As Helpful if my post has been helpful for you.]

Answer 3

Hi,

Take a look at the new functionalities of Excel 2013 (preview):

• What’s new in PowerPivot in Excel 2013
• What’s new in Power View in Excel 2013 and in SharePoint 2013

Regards,

Tiago.