Customer has an Excel 2013 sheet that only shows 65,536 lines while the character limit should be 1,048,576.
The potential cause could be the Row Height is set to 0 after row 65,536
- Open Excel file
- Confirm what the Row Height is of the cells before you begin by right clicking any row and selecting Row Height
- 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
- Make the row that height of the previous cells and you should see more rows below.