ASP to Excel
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