+ Reply to Thread
Results 1 to 2 of 2

Have I installed power-pivot correctly? I'm missing buttons in the ribbon.

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Texas
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    2

    Lightbulb Have I installed power-pivot correctly? I'm missing buttons in the ribbon.

    (1)My power-pivot ribbon seems to be missing several buttons in the ribbon including "New Measures" and "Create Link Table".
    (2)My alleged power-pivot seems to be an ordinary pivot-table.
    Can anyone enlighten me

    Facts:
    *MS Excel 2013 MSO, 64-bit (part of MS Office 365 ProPlus)
    *I have verified the following: File>Options>Add-Ins>Active Application Add-ins (MS Office PowerPivot for Excel 2013; PowerView; QBExcelReportUpdater, QQube; Send to Bluetooth)
    *I have verified the following: File>Options>Customize Ribbon>All Commands "New Measure", "Delete Measure", "Measure Settings" are not listed as choices.
    *My Power-Pivot ribbon does not have either active or grey-outed: "New Measure", "Delete Measure", "Measure Settings"
    *Attempting to use Power Pivot w/ 3rd party software called QQube. I successfully downloaded their sample "Job_Cost(PowerPivot).xlsx-Excel data and yet it seems to be an ordinary power-pivot table.
    *I attempted to use power-pivot by created 3 relational data base tables and when I attempted to link the tables using common fields I noticed I did not have the "Create Link Table" button in my ribbon.

    Notice the "New Measures" button is not in the ribbon.
    power-pivot-1.jpg

    Here I created 3 tables and unlike the Youtube video I was following there is no "Create Link Table" button in the ribbon.
    power-pivot-2.png

  2. #2
    Registered User
    Join Date
    10-22-2014
    Location
    Texas
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    2

    Re: Have I installed power-pivot correctly? I'm missing buttons in the ribbon.

    I solved the issue. I have watch numerous videos to understand how to use power-pivot tables and all the videos I watched were Excel 2010 power-pivot tables. I use Excel 2013. What I did not realize was the GUI for Excel 2013 is vastly different from Excel 2010.

    In Excel 2013, when you are in the power pivot table you see the title, "PivotTable Fields". This text led me to believe that I was in a regular pivot table. In Excel 2013, while using the power-pivot table the title clearly states you are using a power-pivot table...

+ 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. Custom ribbon buttons don't export correctly
    By davejoseph98 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2013, 11:13 AM
  2. Replies: 2
    Last Post: 02-09-2013, 06:53 AM
  3. Mix up of buttons in Excel Add-In ribbon - how to delete buttons?
    By lausianne in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-11-2013, 08:51 AM
  4. Power Pivot not displaying on ribbon
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-28-2012, 02:41 PM

Tags for this Thread

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