• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

Allow Excel to have more than 64000 rows

How can I make MS Excel 97, allow for more than 64,000 rows in the table.
0
whoami
Asked:
whoami
1 Solution
 
abaldwinCommented:
Not at this time.  That is one of the restrictions in the program specifications.

If you can describe why you need to do this we may be able to come up with another solution to your problem.  If you are dealing with some sort of data problem (I would assume you are)I would suggest going to tables in ACCESS.  
0
 
calacucciaCommented:
Supporting ABaldwin.

This restriction is unchangeable. As he says, a description of what you need exactly in particular could guide us into a workaround.

Calacuccia
0
 
whoamiAuthor Commented:
I was just wondering because I am pulling data (customer ship to's)  From a Censys database on an A/S400 and then exporting it to excel so that I can sort it and then do some modifications.  I did get it to fit through some further filtering that I had not intended on doing but I will still be ok.  I have 65530 rows and the limit is really 65536 so I am ok now but I was wondering if this was changeable and if so how.  

CShenberger

abaldwin post an answer and I will award you the points because that was the answer  that I needed yes and how, or no it cannot be done.

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
vbkidCommented:
WhoamI,
Please check out the following URL. The Question was very similiar to what you are asking.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=msoffice&qid=10263945 


<vbkid>
0
 
LaffersCommented:
Personally I'd recommend Access like abaldwin says.  You can import data into a table and sort/manipulate it very easily.
0
 
abaldwinCommented:
I do a lot of data manipulation like that as well.  I see the end of my data beginning to fill the excel sheet and start to stress a little.  One possible solve for it though is to export the data to a delimited text file.  Then in excel write a macro that reads the first 65k records or so and places them in the excel first sheet.  Then places the next so many in the second sheet.

That is if you are intent on using excel for the manipulation, which under some circumstances I can understand.  Of course if you can get it to a delimited text file then you can directly import it to Access and do away with the worries of the lenght anyway.  

Glad I could help.
Andy
0
 
whoamiAuthor Commented:
I would have exported it to a delimited text file except that the program that I am exporting it from doesn't have that option.  
 Thanks for the help

CShenberger
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now