Is there a size limit when generating an excel document out of a web page using Response.ContentType = "application/vnd.ms-excel"

Question

Is there a size limit when generating an excel document out of a web page using Response.ContentType = "application/vnd.ms-excel"

Answer 1

By default with buffering turned on IIS6 will limit the output to 4MB (see KB925764), this can be increased by turning off buffering (and assuming you use multiple calls to write) or by tweaking the AspBufferingLimit Metabase value.