Configure Excel Services (Monitoring Server)
Updated: 2009-09-03
In Microsoft Office, you can publish an Excel workbook to Excel Services, which enables the workbook to be a data source for a PerformancePoint Dashboard Designer. This section explains how Excel Services must be configured in Microsoft Office SharePoint Server 2007. To learn more about planning Excel Services security, see Plan Excel Services security (https://go.microsoft.com/fwlink/?LinkId=108752&clcid=0x409). To learn more about how to create an Excel Services report in Dashboard Designer, see Create an Excel Services report by using PerformancePoint Dashboard Designer.
Note
Excel 2007 will not work as a data source if PerformancePoint Dashboard Designer is installed on a 64- bit operating system.
Three settings must be configured for Excel Services to enable your users to publish a workbook.
| Setting | Description |
|---|---|
Excel Services unattended service account |
A low-permissions account that Excel Calculation Services can impersonate when establishing a data connection. The account uses single sign-on (SSO) credentials from an environment that is not Windows-based, or None, as the authentication method. None is another authentication method for Excel Services deployment. Note This setting is a requirement only for servers that do not have Kerberos enabled. If you have Kerberos enabled, you can skip this setting and proceed to "Excel Services Trusted File Locations." |
Excel Services Trusted File Locations |
Determines who can act as an author for workbooks that are available under Excel Services. The trusted locations can be designated as SharePoint locations, UNC paths, or HTTP paths. Excel Services loads workbooks only from directory paths that the administrator designates. |
Excel Services Trusted Data Connection Libraries |
SharePoint document libraries that contain Office data connection (.odc) files. The .odc files are used to centrally manage connections to external data sources. |
This article gives procedures for configuring Excel Services.
Configure the settings for the Excel Services unattended service account
Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
On the Central Administration home page, click Shared Services Administration.
On the Manage this Farm's Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.
On the Shared Services Administration page, click Edit Excel Services Settings under Excel Services Settings.
Next to External Data, enter the Unattended Service account information. Type the same domain and user name that you used to configure the Single Sign-On service. Make sure that you use an account that has limited Write permissions.
Add a trusted file location
Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
On the Central Administration home page, click Application Management.
On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm's Shared Services.
On the Manage this Farm's Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.
On the Shared Services home page, in the Excel Services Settings section, click Trusted file locations.
On the Excel Services Trusted File Locations page, click Add Trusted File Location.
In the Address section, type the location and name of the SharePoint Office SharePoint Server 2007 document library that you want to add as a trusted file location in Excel Services. If the document library is stored in the Microsoft Windows SharePoint Services 3.0 content database, ensure that Windows SharePoint Services 3.0 is selected as the Location Type.
In the External Data section, select the type of data connections that you will allow workbooks in this trusted file location to contain and click OK.
Add a trusted data connection library
Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
From the Administrative Tools, open the SharePoint Central Administration Web application.
On the Central Administration home page, click Application Management.
On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm’s Shared Services.
On the Manage this Farm’s Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.
On the Shared Services home page, in the Excel Services Settings section, click Trusted data connection libraries.
On the Excel Services Trusted Data Connection Libraries page, click Add Trusted Data Connection Library.
Type the address of the data connection library that you want to configure as a trusted data connection library and click OK.