How many rows?
I've seen errors where large XLS needed to be opened with XLSX.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Rasch
Sent: Wednesday, May 31, 2017 3:50 PM
To: Midrange Systems Technical Discussion
Subject: Odd error downloading a file to a spreadsheet
Hi folks,
We have recently encountered errors from an existing application that downloads error records to a spreadsheet.
Just spent an hour on the phone with the PC support person and flipped every option and parameter in Excel we could find.
The error is this:
The document is corrupt and cannot be opened. To try and repair it, use the Open and Repair command in the Open dialog box
and select Extract Data when prompted.
A little background. I suspected bad data in a record so I did some CPYF's around it but no help.
Then, after other tests, discovered it was a size type problem, as anything over 12,xxx records would fail.
We recently upgraded to Excel 2013, but back versions do not seem to work, either.
Any recent experiences appreciated.
Thanks in advance,
Dan Rasch
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
As an Amazon Associate we earn from qualifying purchases.