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

Madhav Gadve (gmadhav) 0 Reputation points
2023-05-22T16:07:22.4833333+00:00

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.
5,094 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Madhav Gadve (gmadhav) 0 Reputation points
    2023-05-24T18:31:07.6033333+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.