Excel and Solver -- Workbook is currently referenced by another workbook error

If when using Solver in Excel you receive an error the add-ins may need to be reset


Solver Error: "This workbook is currently referenced by another workbook and cannot be closed"

Workbook currently referenced


To Reset Solver Add-in in Excel

  1. From the File Menu, select Options
    File Menu select Options

  2. Select "Add-ins" in the left nav then at the bottom of the windows, ensure the "Manage:" drop-down displays "Excel Add-ins" and hit the Go... button

    Select Add-ins and Go

  3. Uncheck all the boxes, then click OK
    Solver Table Uncheck Boxes

  4. Exit Excel
  5. Open Excel and a black workbook
  6. Repeat steps 1-4 rechecking the boxes that were previously unchecked





Keywords:Microsoft error   Doc ID:63468
Owner:Sasha K.Group:UW Stout
Created:2016-05-17 15:43 CSTUpdated:2016-05-18 09:59 CST
Sites:UW Stout
Feedback:  2   0