When a workbook has a reference to an add-in, Excel will store this reference with its entire path. Now, when a workbook gets opened in Excel, and it has a reference to an add-in, which has not been opened yet, Excel will try to open the add-in, from the path that was stored in the reference. If this is not successful (for example, the workbook was saved on another machine with a different file location) Excel will add the "Missing: solver.xla" reference. To fix this, you would have to open solver.xla (or solver.xlam) by invoking Solver from Excel, before opening your workbook. Then open your workbook and save the workbook.
Bookmarks