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.

Additional Information 

If the above steps do not resolve the issue, please make sure that the Headers are not locked. 

Unlock Headers, paste all the required data from Excel to Winshuttle script and lock headers after that.