Note: I am using Excel 2007. I have a spreadsheet that I import, which currently contains 65536 rows (max rows in Excel 2003?). The spreadsheet is an .xls file, and only contains data in the first ~1000 rows. New data gets added to the spreadsheet each week, so the rows of data will continually grow, but should never grow more than 2000 rows total.
My issue is that the spreadsheet contains 65536 rows total, but data is only in the first ~1000 rows. I have tried to manually delete the rows that do not contain data, as well as deleting them via VBA. Either way, the rows do not get deleted... It's like there is a lock on the total number of rows, declaring that there must be 65536 rows at all times. Could someone enlighten me on this?