News for hackers. Stuff that matters.
Re:$100,000 Revenues in last 12 months - wow by Dobbs on Tuesday October 12, 2010 @11:50AM (#1783800)
> I love Excel and wish more people would actually spend the time to learn the nuts and bolts behind it. Most people think of it as a band-aid solution used by people who don't know databases

Excel is a powerful tool and it is super useful when you use it within its domain.

At the same time it is used as a band-aid solution by those who don't know how to use a database. I recently had a fellow employee come and ask me if I knew how to expand excel beyond the 70,000 row limit. After asking him a few questions I came to the conclusion that his issue was not that excel doesn't support more than 70,000 rows but he needed a database and wasn't using one.

Re:$100,000 Revenues in last 12 months - wow by sedachv on Tuesday October 12, 2010 @12:48PM (#1783991)
What was the reason you thought he needed a database?
Re:$100,000 Revenues in last 12 months - wow by mhill on Tuesday October 12, 2010 @12:59PM (#1784041)
To support more rows than 70000?
Re:$100,000 Revenues in last 12 months - wow by jmatt on Tuesday October 12, 2010 @07:44PM (#1785453)
That isn't the case with xslx files. Only the old binary xls files have that problem.

  Excel 2007+ ------- 1,048,576 x 16,384 (rows x columns)
  Excel old-2003 ----    65,536 x    256