Is my power-pivot ribbon missing buttons? Not a power-pivot?

HappyJohn

New Member
Joined
Oct 2, 2014
Messages
3
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 powe-pivot table.

I hope this is an easy fix.
(1)My power-pivot ribbon seems to be missing several buttons in the ribbon including "New Measures"
(2)My alleged power-pivot seems to be an ordinary pivot-table.
Can anyone enlighten me
 
Last edited by a moderator:

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Well uh....this was not by choice. After I saw my attempt to post screen shots failed. I had a message from my browser that mrexcel.com is not responding. When I was finally able to get the website to respond, the 10 minute editing deadline had passed and I could neither edit nor delete this post to start over. Per the forum rules I'm not allowed to post this issue a 2nd time. When I choose "insert picture" my only choice is a URL so I don't know how I will insert my screenshots (I can post screen shots on other forums).... Your signature says you are a Power Pivot consultant. So does your power-pivot skill set include a solution to my dilemma?
 
Upvote 0
WOW.

I'm in the Matrix.

Happy John, I don't think anyone is going to mind you attempting to restart this thread minus the "I can't figure out how to work them either screen shot"

I suggest DropBox or something like that for your screen shots.

The peeps here are helpers.

Stay Happy
 
Upvote 0
On your Power Pivot ribbon, you have the "Manager" button the far left, that brings up the power pivot window?

New Measure (etc) are actually 2010 style... you will now see a Calculatd FIelds dropdown instead.
 
Upvote 0
Thank you! Thank you! for the reply. I do have a "Manage" button on the far left. My screen looks like the screen on this link:
Start Power Pivot in Microsoft Excel 2013 add-in - Excel
Finding this picture is a relief because after watching numerous Youtube videos and not seeing my MS Excel 2013 power-pivot screen I felt perhaps I installed power-pivot incorrectly. I did not realize the power-pivot ribbon menu had changed so radically from Ex2010 to Ex2013. I'm embarrassed to think of the time I spent on this issue... I call this question solved. Thank you.
 
Upvote 0

Forum statistics

Threads
1,224,045
Messages
6,176,063
Members
452,703
Latest member
kinnowboxes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top