Forum Discussion
Question about the excel spreadsheet row limit
Hi, I'm having trouble understanding what is meant by the excel worksheet/workbook row limit of 1,048,576 rows. Does this mean that Excel cannot display a greater number of rows or that it c...
When I open it, I get this message:
If I press yes, then I get this message:
In excel, it only shows the first 1,048,576 rows, as expected. When I close out of excel, it asks if I want to save. If I say yes, then the rows after 1,048,576 rows are removed (checking in R). If I don't save, they remain.