Excel Web Access Web PartThe following are the properties of Excel Web Access Web Part:
Using Excel Web Access Web PartPlease use the following procedure to use an Excel Web Access Web Part.Step 1: Create a PageOpen your site and create a new page and name it as Excel.Step 2: Add Web PartEdit the page and choose the insert a web part option. From the Business Data group choose the Excel Web Access web part.Step 3: Select FileClick on the link highlighted below.In the tool pane select the Excel work that was uploaded to a Document Library.For the time being I am using a sample Excel file as shown below.Step 4: Test PageClick Ok to the tool pane and save changes to the page. You should be able to see the Excel file within SharePoint page as shown below.Please note the sheets as well. For downloading the file you can use the File > Save menu.Note: Please note that you don't require Microsoft Excel to be installed in the machine. Alle the Excel cells are rendered using Excel Services application and browser.Prevent DownloadOpen the page in edit mode and choose the Edit Web Part option of the Excel web access web part. Uncheck the option Open in Excel, Download, Download a Snapshot.Save the changes and refresh the page. You should be seeing the Download options hidden now.ReferencesOverview of Excel Services in SharePoint Server 2013.SummaryIn this article we have explored how to use the Excel Web Access Web Part.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members: