Excel simply isn't going to handle this. Excel's limit cannot be changed. The only way you'll get more rows is to add more sheets. But, even if you do this, I doubt you'll get 2.5 million rows into Excel, no matter how many sheets you use. It sounds like you're trying to treat Excel as a database, something which it's not designed to do. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

The values of the options are supposed to be unique. The only thing that is sent back from the browser in the postback is the value of the selected option, so if the values are not unique, you can't know which option was really selected. If you really can't use unique values, you have to handle the detection of the selected option all by yourself. You can put a Javascript in the onsubmit event in the form, that gets the selectedIndex from the html element that the dropdownlist generates, and puts it in a hidden field. --- single minded; short sighted; long gone;

I'm not really sure exactly what you're trying to accomplish here, but I think this code below might suit you better: string[] arr = new string[dt.Rows.Count * dt.Columns.Count]; int i = 0; int j = 0; foreach (DataRow dr in dt.Rows) {     j = 0;     foreach (DataColumn dc in dt.Columns)     {         arr[i] = dr.ItemArray[j].ToString();         j++;         i++;     } } The results of this would be an array structured as: [0] = row1 col1 [1] = row1 col2 [2] = row1 col3 [3] = row2 col1 ... Hope that helps, if it doesn't be a little more clear on what you're trying to accomplish and maybe we can come up with something better. - Arcond