+ Reply to Thread
Results 1 to 6 of 6

Power Pivot not showing in excel 2016 one time purchase version

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Power Pivot not showing in excel 2016 one time purchase version

    I just bought the excel 2016 for $110 just so I could put my hands on the power pivot but it’s missing. I already checked the COM add in but no power pivot there. Does anyone what’s the issue is?

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Pivot not showing in excel 2016 one time purchase version

    this is Ex2016 pro plus?

    maybe try Power Pivot is not on the ribbon
    Last edited by sandy666; 01-22-2018 at 08:07 AM.

  3. #3
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: Power Pivot not showing in excel 2016 one time purchase version

    Quote Originally Posted by sandy666 View Post
    this is Ex2016 pro plus?

    maybe try Power Pivot is not on the ribbon
    No just regular version. According to this article, https://support.office.com/en-us/art...7-20b87e1c2a4b it should work

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Pivot not showing in excel 2016 one time purchase version

    What does that mean: regular
    Did you try suggested link?

    or try this:
    1. Click File > Options.
    2. Click the Advanced tab and scroll down to Data.
    3. Check the Enable Data Analysis add-ins: Powerpivot, Power View, and Powermap box.
    Last edited by sandy666; 01-22-2018 at 09:35 AM.

  5. #5
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: Power Pivot not showing in excel 2016 one time purchase version

    Quote Originally Posted by sandy666 View Post
    What does that mean: regular
    Did you try suggested link?
    Okay, I finally solved it. I deleted excel and installed it again. And, then I deleted the register key and it worked!

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Pivot not showing in excel 2016 one time purchase version


    it means that you have uninstalled OFFICE completely and you have removed OFFICE key from the registry and then installed the new version

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot Table Background Color in 2016 Version
    By cyliyu in forum Excel General
    Replies: 1
    Last Post: 08-28-2017, 03:32 AM
  2. Replies: 0
    Last Post: 12-01-2016, 05:26 PM
  3. [SOLVED] Time overlapping In Excel version 2016
    By RayRay10k in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2016, 10:57 AM
  4. Time overlapping In Excel version 2016
    By RayRay10k in forum Excel General
    Replies: 9
    Last Post: 09-23-2016, 05:56 AM
  5. PowerPivot in 2016 Excel version
    By beginner_excel in forum Excel General
    Replies: 2
    Last Post: 06-27-2016, 08:15 AM
  6. Replies: 0
    Last Post: 01-09-2016, 02:02 PM
  7. Replies: 4
    Last Post: 06-19-2014, 12:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1