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.
LVL 4
whoamiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.