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.

Add the Excel Web Access Web Part

To add the Excel Web Access Web Part to the recruiting page, follow these steps:

1. Browse to the home page of the recruiting site and choose Edit Page from the Site Actions menu in the top-left corner.

2. Click Add a Web Part in the left zone and select Excel Web Access from the Business Data Web Part list.

3. Click Add.

4. From the edit menu in the top-right corner of your Excel Web Access Web Part, choose Modify Shared Web Part.

5. In the Workbook field, enter or browse to the URL of the published resource management file.

6. Enter the default tab that you want to show in the Named Item field.