Publishing Pivot Table in Excel 2010

<Question to Dr ExcelAdvsior>

I was trying to publish a pivot table on excel 2010 with powerpivot add on, but I do not know how to save with feature interactivity likes in excel 2003

<Question to Dr ExcelAdvsior>

I was trying to publish a pivot table on excel 2010 with powerpivot add on, but I do not know how to save with feature interactivity likes in excel 2003. I tried to save with publish pivot table option but the web page stilled freeze liked the designing in excel.

How do I publish it to get the result like an add interactivity option in excel 2003? I knew that this option was removed since excel 2007 but what feature that replace it?

<Answer>

Well,you can create slicers and page filters and these should be still “interactive” on SharePoint. If you cannot open the workbook in SharePoint at all, you should make sure that you have installed the PowerPivot components correctly.

7_references.htm

Pivot Table Slicer (Report/Page Filter Slicer)

<iframe title=”YouTube video player” width=”480″ height=”390″ src=”http://www.youtube.com/embed/zgt7SdrYJqg” frameborder=”0″ allowfullscreen></iframe>

Leave a Reply