Forum Discussion

Haha88's avatar
Haha88
Copper Contributor
Apr 10, 2022

Power Pivot add-in not working/enable excel 2019

Hi,

I'm wondering if anyone might know how to troubleshoot the issues I'm having with power pivot add-in with excel 2019 (home & student).

I can see the add-in is available, but Power pivot tab didn't appear when selected

I did a bit of research and it looked like the below function is not available in the data tab

I un-installed MS and re-installed. The issues remain unchanged.

I'm wondering if there's an option to install just power pivot add-in for excel 2019 to use aside.

Thank you in advance.

Haha88

 

 

BI & Data Analysis
excel
power bi

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 10, 2022

    Haha88 

    Based on screenshot you didn't select Power Pivot, thus it's not visible

    Try to check it and restart Excel.

    • Haha88's avatar
      Haha88
      Copper Contributor
      Apr 10, 2022

      SergeiBaklan Thank you for looking into this matter for me. The screenshot didn't tick just for illustration purpose. I ticked the power pivot optionand restart Excel, it still didn't show up.

      Thanks,

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 11, 2022

        Haha88 

        Sorry, have no other ideas. Based on Where is Power Pivot? (microsoft.com) Power Pivot shall be included in your version of Excel. Starting from 2016 it's build-in or not, there is no way to install it separately, only to activate within Excel.

        If only try to repair your Office.

Resources