Share via

how do i download analysis toolpak

Anonymous
2023-06-30T01:10:08+00:00

Whenever I click on "options" where add ins is supposed to be the only thing that pops up is an option for regional format settings. I tried to look up other ways to download it and everything says the same thing but it doesn't work.

Microsoft 365 and Office | Excel | For education | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2023-06-30T01:37:06+00:00

    I have no idea what "options" you're referring to but there is no download required. The Analysis ToolPak [as well as Solver] is included but does need to be activated. The installation is simple. Go go Tools> Excel Add-ins in the main menu (or click the Analysis Tools tool on the Data tab of the Ribbon or the Excel Add-Ins tool on the Developer tab) then check the box & click OK.

    You may need to restart Excel but the Analysis ToolPak functions will then be available from both Tools> Data Analysis as well as by way of the Data Analysis tool on the Data tab of the Ribbon.

    5 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest