Sharing Excel Workbook Without Uploading To SharePoint Document Library

In this article we will see how to share an Excel workbook without the uploading of the Excel file to a SharePoint Document Library.

For this you will need to use the following procedure.

Step 1: Start the Excel Calculation Services.

 
 
Step 2: Create a new Excel Web Application if not already done.
 
 
 
Step 3: Click on the Manage menu of this app and Configure the trusted location.
 
 
Step 4: Click on the Add Trusted File Location.
 
 
Step 5: Click on UNC as the Location Type and in the Address specify the Network File Share from where you want to display the files.
 
 
Step 6: On the web page, insert an Excel Web Access web part and configure the workbook file location as shown below:
 
 
 
That's it, you will view the Excel files from your network share on SharePoint portal without uploading them.