Forum Discussion
Power Pivot add-in lost - Office365 ProPlus
When strange if full repair didn't help. Latest option i know is full uninstallation of the Office by this fix https://support.office.com/en-us/article/Uninstall-Office-from-a-PC-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8?ui=en-US&rs=en-US&ad=US and install it again from scratch.
However, with that you will loss all your Office settings.
Hi Christoffer,
Office 365 itself is not enough to have Power Pivot, it's available mainly for enterprise subscriptions. You may check is it available for your one or not here https://support.office.com/en-us/article/Where-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b.
As for loading to data model you most probably use Power Query (aka Get&Transform), these are different tools. It loads data to data model which is available for any version (any recent) of Excel, you only don't have Power Pivot to work with data model directly.
Hi Sergei
Thanks - But I feel you haven't taken the time to read my post entirely :)
I have Office 365 Pro Plus - which is the first plan listed in your link.
I had Power Pivot yesterday, faced some issues, and removed it through the registry - After trying to fix the office installation, I can not get the power pivot back.
After loading data to the data model through the query editor, I can not get into the data model and add columns, make lookups, do calculations etc...
I see, sorry,
And if you go to list of COM add-ins from the options do you see Power Pivot here?
Hi again,
No;
When strange if full repair didn't help. Latest option i know is full uninstallation of the Office by this fix https://support.office.com/en-us/article/Uninstall-Office-from-a-PC-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8?ui=en-US&rs=en-US&ad=US and install it again from scratch.
However, with that you will loss all your Office settings.