PowerPivot Sharing

[brian.wethington]

Sorry for the completely novice question. I tried to search the forum for discussion on this, but I might not have been using good keywords.

I'm not new at all to Excel. I do have to say that I stumbled upon PowerPivot today though, so I may not be looking at this all correctly just yet. I am not even sure what I was looking at exactly. I do have to say that so far in just the few things I have looked at my mind has been blown. I am wondering though about sharing the information throughout my company. If I create the information using the PowerPivot add-in is SharePoint the only, or should I say most reasonable way to deploy that information to the field effectively?

 

[MD610]

In Excel 2010, if you are going to have a large number of end users, then SharePoint is the most effective way of sharing. Otherwise, you can send the actual PowerPivot Excel file like a regular Excel file but the end user must have Excel 2010 with the PowerPivot add-in installed locally on their machine. With SharePoint, only a web browser is needed and their version of Excel doesn't matter. They don't even need Excel at all and they don't need to be using Windows.

In Excel 2013, only people with a Pro Plus license can create and edit PowerPivot files but any Excel 2013 user, with any license, can view them and interact with the data/slicers.

Excel 2010 PowerPivot and Excel 2013 PowerPivot are not compatible with one another. You can upgrade a PowerPivot created in 2010 to 2013 but you can't go back once you have converted it.

 

[CBROWN1]

Hi-

When sharing a powerpivot file via sharepoint do I need to enable something on sharepoint in order to allow users to interact with the data/slicers?

Thanks,
Cat

 

[brian.wethington]

Excellent information. I am certain my company will be running XL 2010 for quite some time. I would like to convince my company to start using SharePoint, but that may take some time. In the meantime at least I can start using PowerPivot, and there would only need to be a few of us that have the add-in. Thank you very much for taking the time to explain each scenario. Have a great day!