ie, asp, excel caching???

[alex]

Hello,
My problem is as follows...I wrote an ASP application that
pulls data from SQL based on the query the user specified.
I am using the response.contenttype="applicaiton/x-
msexcel" to display the data in Excel via IE. But it seems
the content is cached that is the displayed data is
independent of the query specified, unless i close down
the browser.

It seems to be a client-side issue as not all clients are
having this problem. Any help would be appreciated.

TIA,
Alex

 

[TomB]

I generally stick an unimportant parameter, randomly generated, on the end
of the URL.
<a href="OpenExcelFile.asp?FileID=7&randomNumber=<%=lngRand%>">Open</a>

where lngRand is a Random number, thus making the browser consider it a new
file.