I have the following code where I get all data into<BR>excel. However my grid has a paging option set to &#039;Y&#039;<BR>and with the paging it is not working.<BR>What should be modified in order to fix this problem?<BR> Dim tw As New System.IO.StringWriter<BR> Dim hw As New System.Web.UI.HtmlTextWriter(tw)<BR> Response.ContentType = "application/vnd.ms-excel"<BR> Response.AddHeader("Content-Disposition", "inline;filename=test.xls")<BR> Response.Charset = ""<BR> Me.EnableViewState = False <BR> grdReport.RenderControl(hw)<BR> Response.Write(tw.ToString())<BR> Response.End()