SharePoint 3.0: Pointing Excel Web Access at a Separate Web Application

There is an additional, configuration step required to display an Excel file stored in a different SharePoint web applications from the location where the Excel Web Access web part is being used. The instructions below explain how to set this up.

1.
Locate an Excel file you would like to display in Excel Web Access. For this example, the Excel file is called, stoplight.xlsx. It is stored in a document library at http://sample1portal.domain.com/excelfiles_site/excelfiles_library/



2.
Verify that the intended audience has permission to view the file.

3.
Verify that Excel File location is trusted by Excel Services.



4.
If you have not done so previously, run the following command:

stsadm.exe -o set-ecssecurity -ssp -SSPNAME -allowcrossdomainaccess true

5.
Add the Excel Web Access web part to a page to display stoplight.xslx. Since you have enabled cross domain access, it will now display regardless if the Excel file is part of the same web application as the Excel file, or in a different web application.

In this example, I am displaying the Excel Web Access Web Part on a sub site of http://sample2portal.domain.com although the Excel file is being stored on http://sample1portal.domain.com.