Create a Trusted File Location
Scenario/Problem: You need to create a new trusted file location for Excel Services.
Solution: Use the New-SPExcelFileLocation
cmdlet.
The New-SPExcelFileLocation
cmdlet can be used to create a new trusted location to access Excel workbooks. Provide the address of the location and the Excel Services Application instance, as shown in Listing 21.1.
New-SPExcelFileLocation -Address "http://sp2010/Excel Workbooks"-ExcelServiceApplication "Excel Services Application"-LocationType SharePoint -IncludeChildren
The -LocationType
parameter can be one of the following:
• SharePoint
(default)
• UNC
• HTTP
The -IncludeChildren
switch parameter is used to specify that any ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.