Power Pivot Connection Help Please!

[lameth]

Hello All... first time poster.

I have created a Report Book using POwer Pivot. Its connected to an outside excel master book that all the data in it. I then placed both books on a shared drive at my office. The purpose of this is that all that can access the drive could view it. But when you go to another computer, other then mine, and try to access it.. you can, but you cant use any slicer or filter.. it says the "connection is not working, check with your admin" (paraphrasing). Help! i need other to be able to access this and use the slicers. Do they all need power pivot to use the Powerpivot book and its funtions? Is this something I did not pick in the file that would allow others to use these funtions? You can call the file up and basically view it, but that all.

thank you all!!

David

 

[MD610]

David,

Yes, all users need the PowerPivot add-in installed to view/interact with the workbooks as standalone Excel files. The only way to get around all users needing PowerPivot is to upload them to a SharePoint site that is enabled for PowerPivot. Then the files just show up in a browser and the end user doesn't even need Excel installed on their local desktop.

 

[lameth]

Thank you so much! can you maybe give a little direction in using Sharepoint and if there is soemthing I need to do to the book to allow this? Basically, i have sharepoint and we all use it, but i have never posted on it. We use it for things that IT has already put on it.

Any direction or instruction on how to post to Sharepoint with Power Pivot would be great!

 

[MD610]

I would talk to your IT people. Only SharePoint 2010 Enterprise or later support PowerPivot Services. Also, the SharePoint Admin must enable it to work in the first place.

Once configured, uploading the workbooks is pretty much as simple as saving the file to the appropriate SharePoint location.

 

[lameth]

thank you Mike!