Description

Customer has an Excel 2013 sheet that only shows 65,536 lines while the character limit should be 1,048,576.

Applies To

Excel 2013

Cause

The potential cause could be the Row Height is set to 0 after row 65,536

Solution

1. Open Excel file
2. Confirm what the Row Height is of the cells before you begin by right clicking any row and selecting Row Height
3. After confirming the Row Height, go down to the bottom of the Excel file and select all rows and right click the last row and select Row Height
4. Make the row that height of the previous cells and you should see more rows below.