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.