Re: Odd error downloading a file to a spreadsheet

There were 13,xxx rows.


________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
Sent: Thursday, June 01, 2017 2:03 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Odd error downloading a file to a spreadsheet

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
--
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