Can I add Excel Home ribbon buttons to my custom ribbon? Ex: "Analyze Data"

Madhav Gadve (gmadhav) 0 Reputation points

I want to add "Analyze Data" button to my custom ribbon and access "Analyze Data" from my ribbon tab instead of Home ribbon tab. I am developing Excel addin(XLAM) for Mac environment.

In the attached screenshot:

  1. Is the Excel Home Tab
  2. "Analyze Data" button on Excel Home tab
  3. "DataView" is my custom xlam ribbon for Mac where I want to add "Analyze Data" button

Note: I tried using "Excel--Preferences--Ribbon & Toolbar" but not able to see my Addin tab there. Tried creating a new tab there and Add "Analyze Data" in there which is working but not able to find the code for new tab.

Excel Version: 16.72

MacOS version: Ventura 13.1 (22C65) 

Community Discussion: Here

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
1,097 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Madhav Gadve (gmadhav) 0 Reputation points

    We found the "idMso" for "Analyze Data". We added below to our customUI.xml and it solved our problem.

    <group idMso="GroupIdeas" />
    0 comments No comments