More than 65536 Lines in Excel 2000?
Posted on 2003-03-19
I use Excel 2000 to manage detailed data requests from our database of 120,000 records. The problem ive encountered is that a lot of the CSV files i get from our database exceed 65536 lines of information, meaning its getting more and more hard to be able to run queries and data requests and be able to manipulate that data in excel 2000. Therefore I was wondering whether there is a similar microsoft product which could handle more than 65536 lines of data as i would prefer to stay with microsoft as our lengthy procedures are tailored to Excel and rely on processes such as 'sort', 'filter', subtotal etc.....
So i guess what im saying is that im sure other spreadsheets probably have similar functions but im not sure my boss will let the procedures change as she relies on Excel a lot too and i don't think would want to change- therefore i will have to split my reports over mulitple workbooks and merge later- which as you can guess is very messy and far from ideal given the complexty of some of the requests i get and the timespan i often have.
Ive heard that there is something that exists in Web Tools in Windows 2000 that is essentially a spreadsheet that can handle many more lines of data but between me and one of our tech guys have not be able to locate this tool, which i was told is simply called 'spreadsheet'.
Can anybody help?