Note: it is possible to use Solver with Excel Online (available from Microsoft Onedrive), but the application is very hard to use and not currently recommended. click the Add-ins button near the bottom left of the next screen click the Options button near the bottom of the left side

Start Excel and click the Data tab at the top. click the Data tab as above and verify that the add-ins show.Įxcel 2010/2013/2016 (including Office 365): check the boxes for Analysis ToolPak and Solver Add-in if they are not near the bottom at Manage Excel Add-ins, click Go click the Add-ins button on the left of the next screen click the Excel Options button near the bottom of the resulting window Otherwise, do the following steps exactly as indicated: If both are there, continue with the respectiveĪssignment. If Data Analysis and Solver show in the Analysis section at the far Start Excel 2007 and click the Data tab at the top. Click Tools again, and both tools should be there. Otherwise click Tools, Add-Ins, andĬheck the boxes for Analysis ToolPak and for Solver, then click If both are there, press Esc (escape) and continue with Start Excel, then click Tools and look for Data Analysis and for

Computers in the SFA Library and the McGee IfĮxcel will not let you activate Data Analysis and Solver, you must useĪ different computer. The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel (See later for instructions for installing Analysis Toolpak on a Mac). Here are instructions for the most common versions. ' Solver.' How you check to see if these are activated on yourĬomputer, and how to activate them if they are not active, varies withĮxcel version. ToolPak,' and linear programming requires the Excel add-in called Forecasting with regression requires the Excel add-in called ' Analysis

Data analysis excel toolpak