Custom XML Ribbon - Button pivot insert not showing

Climo

New Member
Joined
Jul 23, 2021
Messages
9
Office Version
  1. 365
Platform
  1. Windows
Hello !
I am using a custom ribbon design, made in XML, for excel (Office 365 version)

Recently, the button to insert a pivot table suddenly disappeared on my custom tab in the ribbon. It previously worked without any problem.
Related code: <button idMso="PivotTableInsert" label="Vers TCD"/>

Concurrently, the same button on my Insert Tab changed to a split button, I gather the two events are linked. Did they change the idMso (or the way to call them) for this particular function ?
PivotInsert.png


Thanks in advance !
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Try to remove this...
Aaah, it actually shows the custom tab, just not the buttons? And no ui error?
I'll test your xml in a minute

Exactly. It does show the first button (I added it as "control sample"), not the second one.
 
Upvote 0
I just loaded you xml with the two buttons through ExcelDNA. On O365 64 bit.
The Custom tab is visible, before the HomeTab. And also the two buttons are visible and working properly.
1627055548800.png

I am out of ideas.
 
Upvote 0
T
Thank you for the tip ! Unfortunately it did not work this time, it only found errors on third-party add-in.

I tried from a cleaned workbook, deleting all superfluous xml and vba, with only the following xml code. I also deactivated all other add-ins / complements to isolate this part.

XML:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="false">
    <tabs>
      <tab id="TestTab" label="Custom Tab" insertBeforeMso="TabHome">
          <group id="GroupeInsertTableaubis" label="GroupTest">
              <button idMso="TableInsertExcel" size="large"/>
              <control idMso="PivotTableInsert" size="large"/>
          </group>
      </tab>
    </tabs>
  </ribbon>
</customUI>

Result is still the same: it shows only the first button (idMso "TableInsertExcel"), not the second. :/
I also tried with the tag "button" instead of "control", with the same result.
The idMso has changed. You can add the button to the QAT export the QAT customisation to see the new id

try CreatePivotTableFromTableRange instead of the pivotTableInsert
 
Upvote 0
Just bumped into a video from Mrexcel about a new look for QAT and Ribbon. 2 weeks old and Supposedly for insiders for the moment. But it may be the reason behind the issue.
 
Upvote 0
T

The idMso has changed. You can add the button to the QAT export the QAT customisation to see the new id

try CreatePivotTableFromTableRange instead of the pivotTableInsert

Thank you both for your inputs ! You helped me a lot :)

The idMso did indeed change, it is NewPivotTable now. Exporting the QAT was a great idea, but in the end it was even simpler. When adding the button to QAT, I just saw that hovering over the command in the customisation menu shows the idMso in the screentip !
 
Upvote 0
Solution
Thank you both for your inputs ! You helped me a lot :)

The idMso did indeed change, it is NewPivotTable now. Exporting the QAT was a great idea, but in the end it was even simpler. When adding the button to QAT, I just saw that hovering over the command in the customisation menu shows the idMso in the screentip !
Thats's correct. You can see it by hovering!!
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

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