Excel only shows small fraction of rows in large file

Hello,

I was here the other day and got some great help. Now I'm back with a problem that to me feels really weird. I have a file that has been produced using Statistica software. The file is supposed to have around one million rows, and when exported to Excel the file is about 30 MB. When I open the .xlsx file in Excel 2010 only two pages of data appear. The rows also have weird numbering. The first square of the A column is A1. The second is A3833, the third is A6789, then A8161, then A8162, then A8163, then A8164, then A18070.

The scroll button to the left of the screen is long, as if the document was only two pages long. When the scroll button is click-and-dragged a small beige square appears with a row number. This small square seems to be aware that not all rows are shown as it shows many more rows than are visible to me.

What's up with my file?

Hi Devourer,

To start with, can you upload a screenshot image of the excel screen showing first page of data out of two pages ? Thanks.


Regards,
DILIPandey
<click on below * if this helps>

ok


Please mark this thread as [SOLVED]... thanks.


Regards,
DILIPandey
<click on below * if this helps>