cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Power Pivot

areeg mohamed
Copper Contributor

‎Jun 30 2017 07:37 AM - last edited on ‎Jul 12 2019 10:47 AM by

‎Jun 30 2017 07:37 AM - last edited on ‎Jul 12 2019 10:47 AM by

Power Pivot

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 ?

737 Views
0 Likes
1 Reply
Reply
1 Reply
Sergei Baklan

‎Jun 30 2017 07:47 AM

‎Jun 30 2017 07:47 AM

Re: Power Pivot

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.

0 Likes
Reply