Topics Map > Client Services

Adding the Data Analysis Toolpak, Solver add-in to Excel

This the method to add the Data Analysis Toolpak and/or Solver add-in to Excel

The usual "Add-in" option in Excel has XL Miner Toolpak, but that's not the Data Analysis Toolpak. The Add-ins for Excel also refer to the Microsoft Store, which is blocked.

This must be done in the standalone version - not available in the web version.

Windows: In Excel, File (or Home) -> Options -> Add-ins -> Go (button) -> check Analysis Toolpak box (or Solver), click OK, restart Excel.

Mac: Open Excel new/existing document -> Data tab -> Analysis Tools gear icon on right -> check box for Analysis Toolpak (or Solver).

Here is a youtube video of the process - this video might be taken down at some point, so please refer to the written process above if it's gone:  https://www.youtube.com/watch?v=mIoS7IRo36c



Keywords:
Data, Analysis, Data Analysis, Toolpak, Excel, Solver, Add-in, Add-ins 
Doc ID:
144565
Owned by:
David H. in UW-La Crosse
Created:
2024-11-15
Updated:
2024-11-21
Sites:
UW-La Crosse