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.
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
This restriction is unchangeable. As he says, a description of what you need exactly in particular could guide us into a workaround.
Calacuccia
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.
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>
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Thanks for the help
CShenberger
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.