Home

Excel 2016 (O365 E3) Analysis Toolpak and Solver Add-ins not appearing

%3CLINGO-SUB%20id%3D%22lingo-sub-744980%22%20slang%3D%22en-US%22%3EExcel%202016%20(O365%20E3)%20Analysis%20Toolpak%20and%20Solver%20Add-ins%20not%20appearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744980%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20activate%20Excel%20Add-Ins%20in%20Excel%202016%20local%20client.%20File%20-%20Options%20-%20Add-Ins%20I%20have%20ticked%20Analysis%20Toolpak%20and%20Solver.%20After%20a%20short%20loading%2C%20nothing%20happens%2C%20the%20Analyze%20group%20and%20the%20Data%20Analysis%20command%20doesn't%20appear%20on%20the%20Data%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDouble-checked%20the%20Trust%20Center%2C%20Add-Ins%20are%20not%20blocked.%3C%2FP%3E%3CP%3EThe%20Add-Ins%20are%20now%20showing%20under%20the%20Activated%20Add-Ins%20list%2C%20so%20not%20blocked%20by%20GPO%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20an%20O365%20Admin%20setting%20to%20block%20Excel%20Add-Ins%20for%20enterprise%20users%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20dozens%20of%20forums%20posts%20people%20reporting%20the%20same%20in%20the%20past%202%20years%2C%20but%20no%20solution%20offered%20yet.%20It%20either%20appears%20or%20not%20for%20people.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744980%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745045%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20(O365%20E3)%20Analysis%20Toolpak%20and%20Solver%20Add-ins%20not%20appearing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745045%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20did%20a%20test%20on%20a%20different%20machine%2C%20and%20it%20works.%3C%2FP%3E%3CP%3EWorking%20machine%3A%20Office%20365%20ProPlus%3C%2FP%3E%3CP%3EVersion%201708%20(Build%208431.2153%20Click-to-Run)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20working%20machine%3A%20Office%20365%20ProPlus%3C%2FP%3E%3CP%3EVersion%201902%20(Build%2011328.20222%20Click-to-Run)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20why%20is%20it%20working%20on%20the%20old%20version%2C%20but%20not%20the%20new%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Gergely2019
New Contributor

Hi all,

I am trying to activate Excel Add-Ins in Excel 2016 local client. File - Options - Add-Ins I have ticked Analysis Toolpak and Solver. After a short loading, nothing happens, the Analyze group and the Data Analysis command doesn't appear on the Data tab.

 

Double-checked the Trust Center, Add-Ins are not blocked.

The Add-Ins are now showing under the Activated Add-Ins list, so not blocked by GPO etc.

 

Is there an O365 Admin setting to block Excel Add-Ins for enterprise users?

 

I have seen dozens of forums posts people reporting the same in the past 2 years, but no solution offered yet. It either appears or not for people.

 

Thanks

1 Reply

Just did a test on a different machine, and it works.

Working machine: Office 365 ProPlus

Version 1708 (Build 8431.2153 Click-to-Run)

 

Not working machine: Office 365 ProPlus

Version 1902 (Build 11328.20222 Click-to-Run)

 

So why is it working on the old version, but not the new version?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies