Editing an Excel File Using Excel Web Access Web Part

Add Excel Web Access Web Part

Create a sample Excel file as in the following and upload it to a Document Library.

document library

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

excel web access

Then select the Excel file.

select the excel file

In the shown tool pane select the Excel work that was uploaded to a Document Library.

appearing

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

Typing and formula entry

Typing and formula entry

Once the property is changed, save the web part to see the Excel view as shown below. You can try typing in the cells and the view will accept the changes.

edit excel file

Note: The changes can be downloaded using the File > Download command.

Summary

In this article we explored how to enable editing in an Excel web access web part.