Add-ins on Excel for Mac show in drop down menu from 'Tools' but not in the ribbon

Question

Add-ins on Excel for Mac show in drop down menu from 'Tools' but not in the ribbon

Nick Finer 0

I have 3 add-ins to Excel for Mac installed - Analysis ToolPak, Solver Add-in and a downloaded Xrealstats-Mac. However they do not show on the ribbon so I can't use any of them. I have tried unticking them in the dropdown and the re ticking them, restarting Excel but no joy. Thanks for any advice

0 comments

2 answers

Your answer

Answer 1

Bob Jones AKA CyberTaz MVP 437.7K

I don't use Xrealstats so I can speak to it — check the developer's support site.

Solver & Analysis ToolPak are Excel Add-ins provided with the program, so they do not appear in the 3rd party add-ins group on the Home tab. You'll find them in the Analysis group on the Data tab at the right end of the Ribbon. However, they should be usable from the Tools menu as well.

Bob Jones AKA CyberTaz MVP 437.7K Reputation points

2026-01-31T21:33:17.5733333+00:00

To see the installation instructions & FAQ on the Real-Statistics site [click here](https://real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/"Real Statistics Resource Pack for Macintosh")
Nick Finer 0 Reputation points

2026-02-01T17:54:52.3366667+00:00

I know that and did that.
Bob Jones AKA CyberTaz MVP 437.7K Reputation points

2026-02-01T19:23:01.0966667+00:00
Have you tried restarting the Mac?

Do you not have the Excel Add-ins [Solver & Data Analysis] in the Tools menu or on the Data tab as shown here?:

If that's the case please go to Excel> About Microsoft Excel to determine;

Version Number

Type of License

Whether your info is shown as Belongs To

Include that information in your reply.
Nick Finer 0 Reputation points

2026-02-01T20:37:44.1666667+00:00

Many thanks. I

If I click on Add Ins I get this blank line below the ribbon

I do have Data Analysis

These are the Add Ins

Excel version. Version 16.105.2 (26012530)

Licence: Microsoft 365 Subscription

Belongs to: ******@finer.org

Answer 2

Bob Jones AKA CyberTaz MVP 437.7K

The right end of the Ribbon is cut off in the 3rd screenshot but the 2nd one does show the Analysis group which includes Analysis Tools, Data Analysis, & Solver.

I also see that a tab labeled Add-ins has been added to the Ribbon. That is not a standard tab in the Mac Excel UI. What is on that tab?

Is the Office software a personal subscription or is it provided by an employer or some other organization or institution?

Nick Finer 0 Reputation points

2026-02-02T15:15:53.4966667+00:00

Bob - I really appreciate your ongoing help.

This is a personal subscription.

I have opened a new clean sheet and here are the screen shots

Nick
Bob Jones AKA CyberTaz MVP 437.7K Reputation points

2026-02-02T19:43:35.1233333+00:00

Then I'm not clear on what the problem is...

Both Solver & Data Analysis appear on the Data tab which is where they should be located. They do not appear on a separate Add-ins tab or anywhere else on the Ribbon.

The Add-ins tab must have been created by the installation of the 3rd party add-in but the tool failed to be added to that tab. You can remove the real-stats add-in then reinstall it but if that doesn't work you need to contact the developer's support group.

[I'm assuming you did download the Mac version, right?]
Nick Finer 0 Reputation points

2026-02-03T09:24:10.4466667+00:00

Thanks - Yup I did install the Mac version. I will contact the developer. Once again thanks for the help