Add a trusted file location

Add a trusted file location

In this article:

About trusted file locations

In Microsoft Office SharePoint Server 2007, a trusted file location is a SharePoint document library, a UNC path, or an HTTP Web site that is configured as a trusted repository for workbooks that Excel Calculation Services can access. Excel Calculation Services opens workbooks that are stored in trusted file locations only.

If you are planning to use a new SharePoint document library as a trusted file location for Excel Services in Microsoft Office SharePoint Server 2007, create the new document library on a SharePoint site. To create the new document library, click the Site Actions menu, select Create, and then clickDocument Library. On the New page, type a name for the new document library and click Create.

Add a trusted file location

Use the following procedure to add a trusted file location.

Add a trusted file location

  1. From Administrative Tools, open the SharePoint Central Administration Web application.

  2. On the Central Administration home page, click Application Management.

  3. On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm's Shared Services.

  4. On the Manage this Farm's Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.

  5. On the Shared Services home page, in the Excel Services Settings section, click Trusted file locations.

  6. On the Excel Services Trusted File Locations page, click Add Trusted File Location.

  7. 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 Windows SharePoint Services 3.0 content database, ensure that Windows SharePoint Services 3.0 is selected as the Location Type.

  8. 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.

In the External Data section, you can determine whether workbooks stored in trusted file locations and opened in Excel Calculation Services sessions can access an external data source. You can designate whether Allow External Data is set to None, Trusted data connection libraries only, orTrusted data connection libraries and embedded.

If you select either Trusted data connection libraries only or Trusted data connection libraries and embedded, the workbooks stored in the trusted file locations are allowed to access external data sources. External data connections can be accessed only when they are embedded in or linked from a workbook. Excel Calculation Services checks the list of trusted file locations before opening a workbook. If you select None, Excel Calculation Services will block any attempt to access an external data source. If you manage data connections for a large number of workbook authors, you might want to select Trusted data connection libraries only.

For information about how to perform this procedure using the Stsadm command-line tool, see Add-ecsfiletrustedlocation: Stsadm operation (Office SharePoint Server).

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable books for Office SharePoint Server 2007.

See Also

Comments

Post a Comment

Popular posts from this blog

WCF WSDL location address Issue resolved when hosted over HTTPS with basicHTTPBinding

Image
Recently I was working on a WCF web service which needs SSL implementation using basicHttpBinding, so that the service remains inter-operable and cater to native clients. Everything was going well, I was able to host my web service over HTTPS (I will detail out the configuration for the same in section below). But when I deployed on Server, following errors were received when proxy is generated: " Metadata contains a reference that cannot be resolved: " " The WSDL document contains links that could not be resolved." The issue lies with the WSDL which generates the location url with client machine name, which restricts generation of appropriate proxy over Internet because it will never be able to resolve machine name over internet. Here is what the Soap Address location and WSDL Import location look like in my WSDL: < soap:address location ="https://MachineName.mydomain.com/MyService/Service.svc" /> < wsdl:import   locati
Read more

Yellow Background issue in Word to PDF conversion

Image
For those who are use to save Word file as PDF might have faced the issue of Yellow background in PDF file post saving (see screenshot)  Below are the simple steps to resolve this issue. You can set a background color for a Word document, but it is only visible in  Web Layout . The background will appear white in  Print Layout . Use the  View  tab's  Document Views  group,  Web Layout  command to see it one has been set. If it has, it can be removed from the  Page Layout  tab's  Page Background ,  Page Color  options. Normally, the colored page background would not print. However, there is a Word Option to  Print background colors and images . Click the  Office button, Word options, Display  and look in the bottom section,  Printing Options  for  Print background colors and images  and unchecked it. Hope this help.
Read more

Gmail tricks - create unlimited siblings of your Gmail address

Use (+) to create unlimited siblings of your Gmail address Many times, you need multiple email accounts for testing and the options you have is to create free accounts imaging if you have to create 100+ accounts for testing and then to test you have to open each and every account to check for the emails. A simple workaround is to get a gmail account and just append a plus (“+”) sign after your email address and after that, you can insert any combination of words or numbers to create any number of personalized email IDs with the same inbox. For instance, if your current email ID is  myname@gmail.com , you can modify email to  myname +sibling1@gmail.com  or  myname +sibling2 @gmail.com  or use any combination to still receive an email with the same ID,  myname@gmail.com . Hence using this Gmail trick, you will be able to create multiple aliases of your primary ID and that too without tweaking any setting or configuration. Tips: You can make use of multiple aliases to sign
Read more