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
- 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.
Comments
0 comments
Please sign in to leave a comment.