Solved

Row limit in Excel 2013

Posted on 2013-06-26
2
897 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 80

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 80

Expert Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Outlook Free & Paid Tools
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

747 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

10 Experts available now in Live!

Get 1:1 Help Now