asp page Options

[emanprinting]

I have an asp page that should display the results of a query in Excel. It used to work on an old server for users in windows NT and Excel 97. Now we have moved to a different server with win XP and the users have win XP and Excel 2000, it no longer works. When the page is invoked, Excel opens but the spreadsheet is blank. I have tested to see that the content is there if I change the format to html and indeed it is there. At the top of my page I have the following two lines:

Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"

If I add the line below, it downloads an excel file correctly:

Response.AddHeader "Content-Disposition", "attachment; filename=query.xls"