I am using PC/Windows10 and excel professional 2019 version. I am currently trying to enable to data analysis add-in in excel sheet, but it is failed to appear on the "Data" tab after I follow the instruction provided online as below. From below screen shot, it shows that the add-in analysis toolpak is available to select. However, it doesn't automatically show on the toolbar after installing it.
Could someone advise what might be the solution for this issue? Thank you.
Click theFiletab, clickOptions, and then click theAdd-Inscategory.
If you're using Excel 2007, click theMicrosoft Office Button
, and then clickExcel Options
In theManagebox, selectExcel Add-insand then clickGo.
If you're using Excel for Mac, in the file menu go toTools>Excel Add-ins.
In theAdd-Insbox, check theAnalysis ToolPakcheck box, and then clickOK.
IfAnalysis ToolPakis not listed in theAdd-Ins availablebox, clickBrowseto locate it.
If you are prompted that the Analysis ToolPak is not currently installed on your computer, clickYesto install it