Solved

Row limit in Excel 2013

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel 2013 Issues 11 44
Web Query 1 19
EXCEL formula that pulls formatting as well 12 43
Import text from rows into columns? 12 31
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

808 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