You did ask them in your title, but I'll toss one in.

Depending on the version, your spreadsheet may simply have too many rows.

Add a counter, to check it. Also, what data types? INT is limited as well to 16K