has anyone ever used all 65,536

[margotb822]

rows available in Excel? What would someone even need that for??

[LynzM]

1. Yes.

I work for a company that manages data. Sometimes when you dump the data out of a database, you get many more rows than that, and you start having to divvy it up... it's annoying! Likewise the limit to how many items can show up in an Excel 'filter'.

[DS1]

2. Easily. In fact I was stunned to find the limit so low

I mean, wtf? It's 2008, make it 60,000,000

[PeaceNikki]

4. In 2007 it's over a million.

And columns increased from 256 to over 16k.

[DS1]

5. Ah, good

:thumbsup:

[PeaceNikki]

6. Indeed. They took out the 1GB memory limit use, too.

Lots of good enhancements: http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx

[TZ]

3. I had a boss at NIH who was an Excel GENIUS

If anyone could do it it was him (we would click on a cell to try to understand what he had done and it was like three lines of formula at least..:scared:)

[PVnRT]

7. I once nested five IF commands into one cell, along with CONCATENATE

I was in the zone that day.

[snooper2]

8. Hit it all the time...

Pain in the ass when doing analysis on 100's of thousands of call detail records