Exporting a large datagrid to Excel

[Kevin]

I'm using a bit of code I wrote awhile ago to render datagrids to Excel
spreadsheets through the browser. The code works great until the number
of rows in the datagrid gets large (approx. 5000), then the user is
prompted for their login credentials a few times then finally they get
a 401 error. The solution for other people who have encountered this
problem is to upgrade their Office 2K to a more current SP. In my case
all my users are running Office 2003 SP1. Has anybody run across this
problem and found a solution?

For reference, here's the method I wrote to render the datagrid

public static System.Web.Http Response
Export_DataGrid (System.Web.Htt pResponse Response,
ArrayList dataGrids,
string FileName)
{
StringBuilder SB = new StringBuilder() ;
foreach(DataGri d dg in dataGrids)
{
//DataGrid newDG = dataGrids[i];
DataGrid newDG = dg;
newDG.EnableVie wState = false;
newDG.CssClass = "";
ClearControls(n ewDG);

StringWriter SW = new StringWriter(SB );
HtmlTextWriter htmlTW = new HtmlTextWriter( SW);

newDG.RenderCon trol(htmlTW);
}

//System.Web.Http Response Response = new HttpResponse(ht mlTW);

Response.ClearC ontent();
Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Charse t = "";
Response.Append Header("Content-Disposition", "attachment ; filename="
+ FileName + ".xls;");
Response.Write( SB.ToString());
Response.End();

return Response;
}