top | item 40817468

(no title)

mfenniak | 1 year ago

Since Excel 2010 that limit is 1,048,576.

discuss

order

metadat|1 year ago

The last time I tried on a Mac a few years ago, it definitely couldn't handle that many. Maybe I was holding it wrong?

Even a million seems embarrassingly puny these days, considering a webpage can have a million checkboxes rendered in only a moment.

jaakl|1 year ago

1M is xlsx file format limitation, and Excel on Mac can work with 1M just fine. But Excel is spreadsheet and not a database, so if you use it for so big datasets (anything over 1000 rows or so) you are very probably just using plain wrong tool.

archiewood|1 year ago

Excel for mac is (intentionally?) crippled.

Any serious Excel user has a PC.

One of the few places remaining where Windows > Mac

supriyo-biswas|1 year ago

Please leave out the snide remarks in spirit of the HN guidelines[1].

> When disagreeing, please reply to the argument instead of calling names. "That is idiotic; 1 + 1 is 2, not 3" can be shortened to "1 + 1 is 2, not 3."

[1] https://news.ycombinator.com/newsguidelines.html