Excel Web Access webpart in SharePoint Online

In this blog post, we will display a Example of Budget in SharePoint Online using the Excel Web Access webpart.

 

Upload Example of Budget into a SharePoint library

I have uploaded an Example of Budget (excel template), and uploaded it into my “Documents” library.

ExampleofBudget

 

Edit a SharePoint page to place the webpart

Let’s start by editing a SharePoint page where we will display the workbook.

  • Navigate to your site
  • Click on the gear icon >> Edit page (or simply click the ribbon > “Page” tab> “Edit”)
EditPage

Edit the page

 

Insert Excel Web Access webpart

On this page, where the cursor is, click on the “Insert” tab in the ribbon, then “Webpart

WebPart

Insert a Webpart

Under Business Data, choose “Excel Web Access” and click “Add

ExcelWebPart

Excel Web Access webpart

When the webpart displays, click on the link saying “Click here to open the pane tool

ClickPanel

Click link on webpart

The panel opens on the right side.
It’s now time to configure the webpart, and link it to our Example of Budget.

  • Under Workbook, click on the ellipses (3 dots)
  • Browse to the location of your workbook (Example of Budget)
  • Click “Insert” at the bottom of the window
FetchBudget

Browse to the workbook

Then configure the rest as you require (i.e.: Title, user interactivity, etc…), and click on “OK

 

The Excel Web Access webpart is now displaying the workbook!

WebpartDisplaysWorkbook

Workbook displayed

Save the page, and… voilà!

PageSaved

 

Loading Likes...

Leave a Reply

Enjoying this blog? Spread the word to help others :-)

%d bloggers like this: