Excel thinks your worksheet iss too large. I.E in Excel 2003 the maximum book size was
1-65536 rows, A - ZZ columns
try selecting all the columns that are unneeded, all the way to ZZ and deleting them
then try your insert operation again.
techp
ASKER
it is excel 2010
Darren S
first, go select the entire column to the right of your last column of data, hold "shift" + "end" and press the right direction key. This will select all blank rows to the right of your data, right click on one of the columns and hit delete. Do the same for the row after your last peice of data but press the down direction key. This should do it
1-65536 rows, A - ZZ columns
try selecting all the columns that are unneeded, all the way to ZZ and deleting them
then try your insert operation again.