Microsoft has just announced that Excel Power Pivot will now be available in all Windows editions of Excel, which is awesome news and a step in the right direction.
Here is what they announced:
I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.
We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.
Previously in the 2016 version of Office 365, you needed to have purchased the Office Pro Plus or Office 365 E3 to have access to Power Pivot within Excel, as I discuss in detail here.
So now you can get Power Pivot in Excel 2010, Excel 2013, and all Office 2016 products, such as:
Power Pivot Office 365 Home, Office 365 Personal, Office 365 Business Essentials, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E1
You can check if your version of Office 365 has Power Pivot Excel available by clicking on the Microsoft Office Support page here.
Happy Power Pivoting!