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.