SharePoint 2007 Excel Web Access Port Number Issue, I think

Question

I am using the following url to display an excel document in the browser:

sharepoint-server:29769/_layouts/xlviewer.aspx?id=http://sharepoint-server:29769/Documents/Cancer/Graphs.xlsx&range=Brain!A4

The problem I'm having is that when I load the url in the browser it returns a download dialog box as opposed to displaying the excel document in the broswer(IE7). What I had noticed is that if I point the id parameter to a url that does not contain a port number it seems to work. Unfortunately at this moment in time I'm unable to have the address put on port 80 and need to fix the issue fairly quickly.

Any tips would be much appreciated. Thanks.

Answer 1

For sharepoint I think you need to enable excel services for the web application running "29769" port through the Central Administration. As you say for port 80 it works , then essentially it means excel services has been configured at the farm level and renders the documents in the browser.

You can validate this using http://yoursite:29769/_vti_bin/ExcelService.asmx

Additionally, please ensure if alternate access mapping are set correctly if your web front servers are running behind nlb. Internal urls must be configured for the intranet zone for the web application running on "29769".

Thirdly, please validate if the browser file handling setting has been set to permissive instead of strict in the web application general settings for the web application running on 29769.