Whatever the convoluted thinking, but it's a joke to have lost the PowerPivot function going from Office 2016 Home, to Office 365 Home, which installs identical with the full apps on the device. (and more reasons such as the 1TB OneDrive cloud storage). Don't know why, but suspect it is because I bought Office 2016 first (upgraded/updated from 2013) in 2015, then earlier this year added an Office 365 subscription to get at those new functions Unfortunately, that solution lost me the newer functions such as IFS. They told me I had to upgrade to Office Proplus.

Microsoft was very little help in trying to figure out if the standalone version had the Powerpivot tables. It looks just like the home addition version but it had the PowerPivot tab. I ran power pivot files in Excel 2016 yesterday () then sent them to a coworker still on Excel 2013 and they ran without issue. I don't think I uninstalled the version that came with the home edition. So far so good I had my update to Excel 2016 installed on Wedendaay (). Power Pivot comes pre-packaged with Excel, you just need to enable it. If you are running Excel 2010, you need to download and install it. Note: This above article was last updated on. If your Excel 2016 isn't from Office 2016 Professional Plus (VL) or Excel 2016 standalone, you can't use Power Pivot in Excel. I had to buy the 2016 standalone version and just installed it. Excel Add-in: Power Pivot is an optional free add-in that works with Excel 2010 or above. For Excel 2016, only Office 2016 Professional Plus (Volume Licensing version) and Excel 2016 standalone include Power Pivot.

Power pivot for excel 2016