have to share or do all the freaking typeing myself.What, there's new typing going on all the time? And you're re-sorting like every other minute?
The naive Excel-centric suggestion: Tell people to close it, then you UN-share, sort, and re-share it. It must be the share that does it -- I just built a test sheet (in Excel 2000) with 3000 rows and 80 columns, and that sorts in approximately no time at all, on my tired old Athlon 500/512 W2KPro box.
The more relevant question: Is this really something one *should* use a *spreadsheet* for??? And, hey -- didn't you just install at least one Open Source RDBMS...? This thing seems to just *cry* for a client-server solution: Throw your data into a table, index it, let everybody access the DB, and you won't frigging *need* to re-sort all the time -- didn't that go out with bell-bottom jeans?!? That's what indexes are for!
Dunnowhere to define whole datarange as database.Me neither -- can't find it in XL2K (have a stoopid Finnish-language copy here, that sucks). From what I can decipher of the help, seems it recognixes that automagically nowadays, so it's not necessary to define it any more. Must have been old superstition on my part...