Jun 30 2017
07:37 AM
- last edited on
Jul 12 2019
10:47 AM
by
TechCommunityAP
Jun 30 2017
07:37 AM
- last edited on
Jul 12 2019
10:47 AM
by
TechCommunityAP
Hello, I need some help regarding Power Pivot. First of all, I do have Office 365 Home Edition. Does this version support it or not? If not, which versions support it. Also, what are the steps to enable the add-on and import database file to work on it in Excel ?
Jun 30 2017 07:47 AM
Hi,
Nope, Power Pivot is not available for Home edition, which versions are supported is here https://support.office.com/en-us/article/Where-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b
With Home edition you have limited functionality to work with data model. You may use Get & Transform to load the data into the model; you may add DAX-calculated measures using PivotTable; you may use linked-back excel tables connected with data model using DAX expression. But all above are workarounds, no way to enable Power Pivot for Home edition.
Former times you was able to install stand-alone full-functional Excel in parallel with O365 Home. Now when on-premises installations are also on CliclToRun that doesn't work.