The services architecture of SharePoint Server 2010 allows for the sharing of services applications to take place. It is important for you to learn about service applications, the design principles that apply, how to deploy them in farms, and elements that have to be considered for successful farming to occur. With SharePoint Server 2010 you [...]

It is possible to have control over access for external data when you define the data providers that you trust and that you record them in your list of trusted data providers. This list of trusted data providers determines the external data providers that you will allow to connect to workbooks that are opened up [...]

There are several trusted file locations that can be leveraged. They include UNC paths, HTTP websites, and SharePoint sites. These are all locations where the use of Excel Calculation Services are permitted to access workbooks. The location section of the Excel Services Add Trusted File Location Page is where you can configure information. This includes [...]

The ability to configure the administrative settings for Excel Services Application can be found by opening the SharePoint Central Administration Web Application. Then the Excel Services Settings page needs to be accessed. It is important for the Excel Services Settings to be configured for several things. External data controls the external data connections for Excel [...]

When you use Excel Calculation Services to open up Excel workbooks, they should be stored in the SharePoint Sever 2010 content database. This is due to the fact that the SharePoint Foundation 2010 will maintain the access control list for the files. You can also open workbooks from UNC paths or HTTP websites with the [...]