?
Solved

Is there a limit how many rows of a csv file can be opened in Excel?

Posted on 2011-02-22
1
Medium Priority
?
301 Views
Last Modified: 2012-05-11
Is there a limit how many rows of a csv file can be opened in Excel?
0
Comment
Question by:jecommera
1 Comment
 
LVL 24

Accepted Solution

by:
Tracy earned 2000 total points
ID: 34953531
Yes, it's limited to the amount of rows allowable in Excel.

For Excel 2000/2003 it's 65,536
For Excel 2007/2010 it's 1,048,576
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

589 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