Problem opening .xls files in IIS 6.0

We recently switched from an IIS 5.0 box to IIS 6.0. The IIS 5 system hosted
xls spreadsheets downloaded by authenticated clients. Now that we have moved
to IIS 6.0, when the client clicks on the link in IE the xml code for the
spreadsheet is displayed.

I got around this by adding xls as a mime type (application/ms-excel) so
they can at least choose to save the file by choosing that option when they
click the link. If they choose “Open” though (which many of them are used to
doing) they are continuously prompted to authenticate again. If they enter
the correct credentials, they login screen comes up again and again. If they
hit cancel, the spreadsheet will open.

Anyone have any ideas?

Re: Problem opening .xls files in IIS 6.0

On Nov 13, 7:14 am, Jason Carter
wrote:
> We recently switched from an IIS 5.0 box to IIS 6.0. The IIS 5 system hosted
> xls spreadsheets downloaded by authenticated clients. Now that we have moved
> to IIS 6.0, when the client clicks on the link in IE the xml code for the
> spreadsheet is displayed.
>
> I got around this by adding xls as a mime type (application/ms-excel) so
> they can at least choose to save the file by choosing that option when they
> click the link. If they choose "Open" though (which many of them are used to
> doing) they are continuously prompted to authenticate again. If they enter
> the correct credentials, they login screen comes up again and again. If they
> hit cancel, the spreadsheet will open.
>
> Anyone have any ideas?


What version of Office/Excel is in use.

Is WebDAV enabled in IIS6 (and do you want it enabled).

Office applications alter their behavior (and sometimes introduce
bogus behavior) based on a few things (mentioned earlier).


//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//

Re: Problem opening .xls files in IIS 6.0

WebDAV is not enabled. We have encountered issues with both Office 2003 and
2007. Office is not installed on the web server at all.

Thanks for your response.

"David Wang" wrote:

> On Nov 13, 7:14 am, Jason Carter
> wrote:
> > We recently switched from an IIS 5.0 box to IIS 6.0. The IIS 5 system hosted
> > xls spreadsheets downloaded by authenticated clients. Now that we have moved
> > to IIS 6.0, when the client clicks on the link in IE the xml code for the
> > spreadsheet is displayed.
> >
> > I got around this by adding xls as a mime type (application/ms-excel) so
> > they can at least choose to save the file by choosing that option when they
> > click the link. If they choose "Open" though (which many of them are used to
> > doing) they are continuously prompted to authenticate again. If they enter
> > the correct credentials, they login screen comes up again and again. If they
> > hit cancel, the spreadsheet will open.
> >
> > Anyone have any ideas?
>
>
> What version of Office/Excel is in use.
>
> Is WebDAV enabled in IIS6 (and do you want it enabled).
>
> Office applications alter their behavior (and sometimes introduce
> bogus behavior) based on a few things (mentioned earlier).
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>
>