Business intelligence with Excel Services 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 171

Table 6-2 describes the three options that you can set when the data connection is created; the
Authentication Settings button for Excel Services is displayed on the last page of the data connection
wizard, for instance.

TABLE 6-2 The authentication settings options

Authentication setting Description

Use The Authenticated User's
Account

This option instructs Excel Services to transform the currently logged-on user's
SharePoint security token into a Windows security token. Excel Services uses the
Claims to Windows Token Service to carry out the conversion.

Use A Stored Account This option instructs Excel Services to retrieve the user name and password from a

target application in SSS and performs a Windows log on. This target application
was previously configured by the SharePoint farm administrator.

None This is similar to specifying a stored account, except that Excel Services now uses

the target application registered under its Unattended Service Account. To specify
an Unattended Service Account, in Central Administration, display the Excel
Services configuration settings and then, under Global Settings, in the External
Data section, register the account credentials. For detailed instructions, see Use
Secure Store with SQL Server Authentication (SharePoint Server 2013) at http://
technet.microsoft.com/en-us/library/gg298949(v=ofice.15).aspx .

Also note that when someone configures a connection this way, that connection can be shared
and reused so that not every user in your organization needs to do this configuration. The best way to
do this is to store the .odc connection file to a SharePoint Data Connection library and let your users
know to select preconfigured connections from there.

The following links provides more information about external data connectivity and configuration:

■ A downloadable document showing more details on configuring Kerberos for Service Appli-
cations (like Excel Services) in SharePoint: http://www.microsoft.com/downloads/en/details.
aspx?FamilyID=1a794fb5-77d0-475c-8738-ea04d3de1147&displaylang=en

■ A more basic webpage showing options for configuring Kerberos in SharePoint 2010: http://
technet.microsoft.com/en-us/library/ee806870.aspx

■ Details on how to configure SSS: http://technet.microsoft.com/en-us/library/ee806866.aspx

■ Specifics of configuring SSS for Excel Services and the Unattended Account: http://technet.
microsoft.com/en-us/library/ff191191.aspx

Opening an Excel workbook in the browser

In this section, we explore viewing and editing workbooks in the browser.

Viewing workbooks
To use Excel Services, simply navigate to the document library where you saved the file and click the
name of the file. Excel Services renders the file in the browser, as demonstrated in Figure 6-11.