I and my IT guy, along with a team of programmers are stumped with this problem.

We use a database query application that runs in a web browser (problem is unaffected by which browser) to query a very large client database. There are two methods of showing the query results; one is a PDF of a preformatted report layout with the results.
The other is to export the results out to an Excel spreadsheet (.xls) and this method has been working just fine for at least a year.

My most-used query criteria will show results of about 3,350 records with each record, of course, showing up as a row within the xls; I call it a "data dump".
Recently, the export is somehow losing or being restricted/limited so that the final download of data only shows 260 records max. When I run this on two other user's PCs, the usual results will export completely with no problem.

Note in the first image the size of the export file that the database app is attempting to download - - 6.11MB.

export1.png

Instead of letting it open in Excel, for this problem solving effort, I chose to Save the file directly and try to open in that way; no difference.
But, look at the difference in file size - - 500KB.

save1.png

Somewhere between the click of the export button in the database application and Excel handling(?) it on into the "opening" of the file, the number of records are being limited.

The programmers claim that they have examined their application code and there are no "limitations" on the export so it must be a problem with Excel. I'm confident that there is nothing on the database side since other users can perform the export; this is strictly on my machine.

We cleared out the %temp% folder, and though that seemed to help - I could run the export once with good results, but since then it back to only the 260 limit

Suggestion / thoughts?

Thank you,
Delain