Custom XML Ribbon - Button pivot insert not showing

[Climo]

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 ?

Thanks in advance !

 

[Climo]

Try to remove this

Just did that, it changed the position of the tab, nothing else...

 

[Climo]

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.

 

[bobsan42]

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.

I am out of ideas.

 

[Momentman]

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.

<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

 

[bobsan42]

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.

 

[Climo]

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 !

 

[Momentman]

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!!