FordTorrey
New Member
- Joined
- Jan 5, 2019
- Messages
- 1
Hi all,
I have data that has been saved as an .xls file that exceeds the row limits of .xls. I can tell that the data is there because when I run a PivotTable the count adds to well over the 65,536 limit but in the displayed spreadsheet the highest row is obviously 65,536. I've tried to save the file as .xlsx/.csv/.txt but only the 65,536 rows in the spreadsheet get exported. I've also tried to change the file extension to .xlsx, but it corrupts the workbook, and changing it to .csv/.txt makes the data unusable.
Does anyone know of a way to access all of the data that's saved in the .xls file? I unfortunately can't post the workbook because it contains contact information.
Any help would be amazing!
I have data that has been saved as an .xls file that exceeds the row limits of .xls. I can tell that the data is there because when I run a PivotTable the count adds to well over the 65,536 limit but in the displayed spreadsheet the highest row is obviously 65,536. I've tried to save the file as .xlsx/.csv/.txt but only the 65,536 rows in the spreadsheet get exported. I've also tried to change the file extension to .xlsx, but it corrupts the workbook, and changing it to .csv/.txt makes the data unusable.
Does anyone know of a way to access all of the data that's saved in the .xls file? I unfortunately can't post the workbook because it contains contact information.
Any help would be amazing!