Showing posts with label Excel trusted file locations. Show all posts
Showing posts with label Excel trusted file locations. Show all posts

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.

Popular Posts