Link to home
Start Free TrialLog in
Avatar of whoami
whoami

asked on

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.
Avatar of abaldwin
abaldwin

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.  
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
Avatar of whoami

ASKER

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.

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

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


<vbkid>
Personally I'd recommend Access like abaldwin says.  You can import data into a table and sort/manipulate it very easily.
ASKER CERTIFIED SOLUTION
Avatar of abaldwin
abaldwin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of whoami

ASKER

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