[pq0ak2nnd]

FTFY:

"Excel THINKS IT CAN DEAL with many gigs of data thanks to PowerPivot and the addition of an in-memory database."

It's so cute when I hit ctrl-downarrow on a blank sheet and Excel sends me to row 1,048,576. Wishful thinking because if I ever filled 1M cells with functions, well... lololololol... time to use JMP...

[TabTwo]

Cisco Global Pricelist, there are still not enough lines in .xlsx to cover all their products

[tomnipotent]

If you're putting the data in Excel's new data model, this is no longer a problem. I regularly have files with tens of millions of rows of data which pivot tables can work against with sub-second aggregations across multiple columns.

[pq0ak2nnd]

Oof.

[tomnipotent]

I'm guessing you've never used these features if this is your comment.

[zhte415]

I still deal with people that are limited to 65535 rows.