.xls spreadsheet after 65,536

[RaxusCraxurFace]

One of my users used .xls rather than .xlsx to create a spreadsheet with over 400k rows.

Took her a long long time to make it, and now when she goes to open it we get the hard limit of 65,536 rows. Even if I convert it to .xlsx we get more rows available but there is no data after row 65,536.

Does anyone know of anyway to retrieve this data?

 

[Twinsen]

I honestly want to say the data has been lost if it was saved as an .xls because the file is truncated due to the XLS limitation. But you could try to open the file with Open Office and see if the data is there.

 

[Armenius]

Sorry to say it's lost. When you try to save a file with more than 0xFFFF rows it will pop this up and tells you in no uncertain terms that data beyond the limit will not be saved. She should have read the warning before saving and closing the file.