Unfortunately many people use it as a database then complain when it is
slow.

I imagine that abuse was further encouraged when they added over 1 million
rows.

"Peo Sjoblom" wrote:

I agree, use a database for storing lots of records, then use Excel to query
the database whether it is using a database query or a pivot table..
Unfortunately many people use it as a database then complain when it is
slow.


--
Regards,

Peo Sjoblom



"Gordon" wrote in message
...
"Peo Sjoblom" wrote in message
...
Excel 2007 has over a million rows, of course it has a new radical design
hated by a lot of people and loved by a few

And in any case, Excel is a data MANIPULATION application, not a database.
Anything with data approaching 60,000 records will be MUCH better served
using a specific database application rather than Excel...