Excel Web Access Web part filter RRS feed

  • Question

  • Hello,

    I have an excel web access part which loads an Excel file with pivot tables. http://nl.tinypic.com/r/54c2v4/9 like this. Now I want to have a filter in excel like a slicer works, I select for example a name and all the tables will be filtered at the same time. for example I filter on asset management, and i'll only see the asset management data but If I change my view I also want to see only asset management data there.

    There is very little documentation here so I hope you guys can help me.

    Thursday, April 14, 2016 7:35 AM


  • Hi AmericanIdiotka,

    Sorry for delayed reply.

    How is everything going?

    If there is the category column in excel file in the excel web access web part, you could use the category column as the filters to connection filter web part and excel web access web part.

    For more detailed information, you could refer to the article below.

    Filtering Excel WebParts in SharePoint using Query String Parameters.


    About overview of all the movies, do you want to show the overview of all the movies according to the urls of the movies in the excel web access web part? If you do, it is not easy.  Because the excel web access web part is used to display content of excel.

    Best regards,

    Sara Fan

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Victoria Xia Tuesday, April 26, 2016 12:43 AM
    • Marked as answer by Victoria Xia Tuesday, May 3, 2016 12:32 AM
    Friday, April 22, 2016 9:38 AM

All replies