Solved

Row limit in Excel 2013

Posted on 2013-06-26
2
914 Views
Last Modified: 2013-06-27
I have tried all the solutions in this thread and nothing works.  We are running Win 7 and Office 2013.  I try to download a file from our IBM AS400 with the add-in to transfer files.  My file has 65,637 records and it errors out saying that there are too many.  I've saved it as a .xlsx file.  I can't find anything about compatibility mode, so I assume that it is disabled.

I need to get this working asap as I have numerous files to download.  What do I need to do??

Thanks.
0
Comment
Question by:ovcfbf
  • 2
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39280243
Which version of the add-in are you using? Excel 2003 was limited to 65,536 rows, so add-ins before V6R1 System i Access and V5R4 iSeries Access service pack SI31388 enforced that maximum number of rows. Later versions permit over a million rows.
http://www-01.ibm.com/support/docview.wss?uid=nas110d0b21ac5c9c08c86256ed000748cbd

As a workaround, you might consider export the file as txt file format. Excel can read those and exceed the artificial limit of 65,536 rows by old versions of the AS400 Excel add-in.
0
 
LVL 81

Expert Comment

by:byundt
ID: 39281359
Since two approaches were suggested, what did you end up doing?
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now