February 2013
Intermediate to advanced
304 pages
8h 26m
English
Scenario/Problem: You need to create a new trusted data connection library for Excel Services.
Solution: Use the New-SPExcelDataConnectionLibrary cmdlet.
The New-SPExcelDataConnectionLibrary cmdlet can be used to create a new trusted data connection location that Excel workbooks can access. Provide the address of the data connection library and the Excel Services Application instance, as shown in Listing 21.5.
Listing 21.5. Creating a New Trusted Data Connection Library
New-SPExcelDataConnectionLibrary-Address "http://sp2010/Data Connections"-ExcelServiceApplication "Excel Services Application"
Upon successful creation of the new trusted data connection library, a summary of the properties is displayed, ...
Read now
Unlock full access