Excel Services Interactive View

Analyze data with Excel on the web

Microsoft has introduced a new web based capability that extends its Excel Services offering.  This new capability provides a limited interactive view of any table in a web page.

An introduction to this service is below.  For those interested in additional capabilities and more advanced and useful capabilities see:

For the consumer:

Learn more about Interactive View

Analyze a table in any web page with a dynamic interactive view

For the developer:

Implement the Interactive View feature for 1 table

Implement the Interactive View feature for multiple tables

Improve the formatting and layout of the 'Interactive View' buttons

As an example, the image below shows a table, the Interactive View button, and the result.

For a live demo, developer tips, and more, please see http://www.tushar-mehta.com/publish_train/data_visualization/15c%20interactiveview/index.htm

Tushar Mehta

One thought on “Excel Services Interactive View

  1. I would like to ask, if it is possibility to add some more additional attributes in Excel Interactive View button command list. I would like to have some kind of a table like this one
    Indicator Year
    2009 2010 2011 2012

    and make filter just for “Year”, I mean, that it would be a possibility to choose year: just 2010 or 2012 or all of its. Now Interactive View button make all columns like filters (Year1, Year2, …) and let me pick particular value of year. I don’t need to choose value in filtered year, I just need to select specific year. Is it possibility to do with this Interactive View Button? At first I found this Button I was surprised and happy, but when trying to do I really need, something went wrong… Maybe it is some other possibility to do like this? I would appreciate for You help!

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.