Status List Web Part

To highlight the importance of the Indicator list items, add them to the home page of the management site so that executives can easily see them every time they visit the site.

To do this, follow these steps:

1. Navigate to the home page of the Management collaboration site.

2. Choose the Site Actions menu, select Edit Page.

3. Click in the content area where you want to add the Indicators and select Web Part from the Insert tab on the Ribbon.

4. Select Status List from the Business Data section.

5. Click Add.

6. From the Edit menu of the Status List Web Part, select Edit Web Part.

7. Browse or enter the path to the Organizational Indicators in the Indicator List field.

8. Select Traffic Lights in the Change Icon field

Excel trusted file locations

1. Open the administration page for your Excel Services Application.

2. Select Trusted file locations.

3. Select Add Trusted File Location in the top navigation bar.

4. Enter the address for the accounting subsite in the Address field.

5. Select that the location is a SharePoint site.

6. Enable the option to trust child libraries or directories by checking the Children trusted box.

7. Enter a volatile function cache lifetime value of 300 (5 minutes).

8. Set the Allow External Data option to Trusted data connection libraries and embedded sources.

9. Select to allow user-defined functions in the Allow User Defined Functions section.

10. Click OK.