• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

file imported to Excel only showing first 100K rows

Tmoedl

New Member
I import a report with around 136,000 rows every week and have done so for years. Now only 100,000 rows show up. Is there a setting I need to change?
 
report is generated in my business system and sends it to my downloads file as .xlsx. Maybe the business system is limiting the size?
 
That might be it indeed. I allow myself to make this remark: the issue is not importing data in Excel, as the excel file is generated by another system.
 
The problem is with the business system. We found a way to work around it. The newer web-based interface was limiting the files size. By using an older PC based interface I am able to export the entire file and down load it into Excel.
 
Back
Top