Solver Sensitivity

Solver Sensitivity for Excel is already installed and ready to use by in the Virtual Computer Lab.

Installing Solver Sensitivity on your personal computer

Solver Sensitivity is available for users to download at https://mba.tuck.dartmouth.edu/toolkit/ installation directions are on that page.

Required Excel settings

  1. Go to the File->Options->Trust Center, and Click on "trust Center Settings..."
  2. Click on the "Macro Settings" section
  3. Under "Developer Macro Settings" tab, check "Trust access to the VBA project object model"

Load Add-In

On Thayer machines M210/CADlab and/or Virtual Computer Lab Solver Sensitivity should automatically load in excel, but if it doesn't you can try the following:

  1. Launch Excel
  2. Select File->Options->Add-Ins, then select Manage="Excel Add-ins", and click on the "Go..." button.
  3. Make sure these 2 options are selected:
    1. "Solver Add-in"
    2. "Solver Sensitivity for Excel,if "Solver Sensitivity for Excel" is missing:
      1. Click the Browse... button and navigate to where you stored SolverSensitivity.xlam.
      2. You will be asked if you would like to copy the file to your Addins folder, click No. Click OK.