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

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?