|
Re: The best elegant solution to override 65k rows limit in a sheet
Bill Sharpe wrote...
....
>Bob Phillips is right. Use a database. If the company has 4 million
>records it should be able to afford database programs for its users.
Doesn't need more than ODBC connections to a central dbms. For those
things Excel can do that databases can't, Excel can't handle even 65K
data points (e.g., LINEST and LOGEST would choke on worksheet-size data
sets). For everything else, use dbms views and queries to categorize
and aggregate.
>I expect Aaron to pop in with his usual rant, too.
In this case Aaron would be dead right. Only a moron would try to
process +4M records in a spreadsheet.
|