sorting a LAAARGE workbook

J

JMAttero

Hello:
I am trying to sort a very large amount of data. Specifically, ther
are 700,000 entries (rows). Since Excel only allows me to plac
something like 65,000 rows on one sheet, I have to put the data on 1
worksheets. Assume that column A is "Date", and that is the column
would like to sort by. The data that I have is not sorted by date. I
there a way to select all of the data on all of the worksheets and do
"sort by date"? If not, is there any way around this problem?

Thanks in advance for any help/direction you may be able to give me.

JM Atter
 
J

jeff

Hi,

I don't believe there is any easy or fast way to
solve your dilemma, other than sorting each sheet
one at a time.

If you load this data regularly from a database, it would
be better to have it sorted there (perhaps selected
via SQL ordering by date? (It might be worth your
while to export the data back out, sort it, and re-import
it.)

jeff
 
H

hcj

Hopefully, someone better in Excel than I can give you a
more direct solution; else, hope this gives you a strategy.

Assuming you need an Excel final product, I'd use Access
or any database program to do this, provided you can hold
all the records in one place and then export back to
Excel. Pull all the records into the database and then
export them out to Excel in worksheet-size batches.

In Access, the exporting query should do the sorting.
You'd need to keep track of which records you had already
exported, probably by looking at the data range selected
for each export batch, then using date range criteria to
limit the record set for each export run.

If you follow this idea, make sure you don't lose data
content through field type mismatch problems - a lot
depends on how "cleanly" the original data is formatted.

Good luck.
 
F

Frank Kabel

Hi
I agree with the other answers that Excel is not the right tool for
this. Use a database which has not Excel's row limitations (even MS
Access should do).
IMHO Excel is not suited to work with more thang lets say 60000 records
 
B

Bill Sharpe

Consider using QuattroPro, which can handle 1,000,000 rows, although I
agree with other posters that with this many records a database is the
application to use.

Bill

Hello:
I am trying to sort a very large amount of data. Specifically, there
are 700,000 entries (rows). Since Excel only allows me to place
something like 65,000 rows on one sheet, I have to put the data on 11
worksheets. Assume that column A is "Date", and that is the column I
would like to sort by. The data that I have is not sorted by date. Is
there a way to select all of the data on all of the worksheets and do a
"sort by date"? If not, is there any way around this problem?

Thanks in advance for any help/direction you may be able to give me.

JM Attero
 
Top