Jean Paul's Blog

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

    Advertisements
  • 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

Editing an Excel file using Excel Web Access web part

Posted by Paul on January 29, 2015


In this article we can explore how to edit an excel file using the Excel Web Access web part.

Add Excel Web Access Web Part

Create a sample excel file like below & upload to a document library.

image

Create a new page and add the Excel Web Access web part to it.

image

Then select the excel file

image

In the appearing tool pane select the excel work which was uploaded to a document library

image

Change the following property of the web part. This is the important step.

· Typing and formula entry

image

Once the property is changes, Save the web part to see the excel view as shown below. You can try typing in the cells & the view will accept changes.

image

image

The changes can be downloaded using the File > Download option.

Summary

In this article we have explored how to enable edit in an excel web access web part.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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