Get over 1 million rows in Excel

A lot of people complain that you can’t work with more than 1 million rows of data in Microsoft Excel. Well, now you can!

Using the Power Pivot plug in in Excel 2013 or the fully integrated Power Pivot tab in Excel 2016, Excel now has a powerful database infrastructure that easily handles many millions of rows stores inside the Data Model portion of the file. Your only limits are really just the amount of RAM and speed of your processor.