Lately, I have been talking to few business folks who do their own data analysis in excel (2010) and sometimes they run into the excel 2010 limit of 1 million rows. And so when I hear that, I talk about Power Pivot and I talk about what It can do and what it cannot and they are just amazed that there’s a FREE add-in that will help them crunch more than 1 million rows!
You can explore more about this amazing add-in here: http://www.microsoft.com/en-us/bi/powerpivot.aspx
And Read more about pros/benefits of PowerPivot:
Top 5 Ways PowerPivot Helps Excel Pros
PowerPivot? But I use pivot tables in Excel
- The State of Microsoft Self-Service Reporting (sqlserverbiblog.wordpress.com)
6 thoughts on “Crunch more than 1 million rows in Excel 2010 with free addin called Power Pivot!”
Reblogged this on IT Lyderis.
Thanks for the solution, i been here with 19 million of row to process, take me almost 2 weeks with mess of result
you’re most welcome!