At a recent customer of mine the question came up as to how we could replace the default people picker with a custom one that was tailored to some very particular AD queries to supplement the SharePoint calls. I read a few posts about replacing it across the board, notably this one: http://www.binarywave.com/blogs/rajesh/Lists/Posts/Post.aspx?ID=4 which for [...]

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 [...]