Older ver of MS excel has limit with 65536 rows per worksheet. Probably excel 2007 may help u !(though not sure) or some vba coding also helps. One more criteria is how did u copy / import rows from where i.e. access table / other databases…. See more info MS ref and excel 2007
If u have pre-excel 2007 wb open in excel 2007 in compatibility mode then, the wb has 65,536 rows, not 1,048,576. (just guessing, but not sure, cause u mentioned “table”).