Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Excel with Parameters

Posted by Paul on February 10, 2015

In this article we can explore how to use Excel Parameters along with Excel Web View web part.


Parameters are Names associated with cells in an Excel workbook. Parameters allows users to change the cell values while in the Excel Web View web part.


Excel Web View web part does not allow editing of cells.

Excel 2013

For the experiment I am using Excel 2013 client application.


Create Parameters

Create a new Excel work book. Add the following cell values and a chart.


Click on the FORMULAS tab.


Now click on cell A1 and then on the toolbar Define Name button. In the appearing dialog enter the name as Parameter1 as shown below.


Repeat the same for other 4 cells and name them respectively. You can see the Name Manager to ensure all the cells are named correctly.


Now we are ready with our Parameters.

Expose Parameters

Now we need to expose the parameters in Browser View options. Those parameters exposed will be workable when the workbook is interacted through a browser.


In the appearing dialog choose the Parameters tab and select the parameters as shown below.


Save the file & now you are ready to deploy the workbook to SharePoint.

Inside SharePoint

Upload the above workbook to a document library, create a new page & insert the Excel Web Access web part into it. Then select the above workbook & Save changes to the page.

You should be able to see the Parameters in the right pane as shown below.


You can try changing the parameter values and click the APPLY button. The graph too should change.



In this article we have explored Excel Parameters with Excel Web View web part.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s