I am exporting an ASP page(a report) to Excel. I use the response.contenttype thing and everything works fine. Sometimes when i have lots of rows, over 10,000 it takes a long time to open. The file downloads fast but when i try to open the excel file it takes real long. The file size is about 2mb but i have other excel files that are 4 megs and have 40,000 rows but they open up in about a second while the excel that i exported from asp is only 2 megs and takes like 10 minutes.

Has anyone run into this problem

I have one table in the page

Thanks,

Luke

Transferring 2 megs over HTTP is not going to be very fast. When you open an XLS file locally, it just has to read from disk. When ASP is generating it, it's going to take some time to generate and transfer.

I save the file first then open it locally. And it takes about 5 to 10 minutes to open up.