Excel Services Application Get File Location In SharePoint 2013 Using PowerShell

This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features of SharePoint 2013 from beginners to advanced users.

In this blog, we will learn about how to get the Excel Service application file location using PowerShell cmdlets. 
SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.

Excel Service Application
  1. Excel Service is a business intelligence tool that allows you to share data-connected workbooks across an organization.
  2. Excel Service in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server.
Why we are using these commands

Excel Services Application loads only workbooks that are stored in a trusted file location.

Steps
  • Open your SharePoint Management Shell.
  • Copy the below code.
  • Run this one.

    Syntax

    Get-SPExcelFileLocation [[-Identity] <SPExcelFileLocationPipeBind>] -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>]

    Example
    Get-SPExcelServiceApplication -Identity "ExcelServiceApplication" | Get-SPExcelFileLocation
Conclusion

Was my blog helpful? If yes, please let me know and if not, please explain what was confusing or missing. I’ll use your feedback to double-check the facts, add info and update this blog.