How to publish a power pivot workbook on a share point 2010 website?

Question

Hi,

here is my problem maybe somebody can help me:

I have published some power pivot charts to a power pivot gallery on my sharepoint 2010 server. 

Now i want to show the charts (with its slicers) on a website. So far i managed to do that via web parts but there are 2 problems i could not get rid off.

1) The first thing is that the within the web part the excel spread sheet is to big(a lot of unused space on the right and beneath the charts and slices). I could not manage to reduce the size of the spread sheet. Maybe someone knows an solution to this problem.

2) I tried to save my excel workbook in different ways (only one sheet, only the charts,...) but I could not find a way to get rid of the excel bar at the bottom of the web part except with only saving the charts but there the problem was that i didn't have any slicers to change the charts.

 

I would greatly appreciate any help.

(Please ignore the mistakes i made, i'm not a native speaker.)

Regards

Answer 1

Hi, I too had a similar problem, & this is conclusion i reached to:

1) Removing space :- when a powerpivot excel sheet is opened in a browser, it occupies the full page. It simply displays whatever was there in excel sheet, as it exist. You cannot modify it in existing available webpart. If required you can develop a custom webpart for that.

2) Saving charts & sheets separately : Excel opened in a browser allows you to download a copy of it, it will download the whole of the excel sheet. You cannot specify selective parts to be downloaded.