Adding reference to Solver in Excel messes up the reference path

[obaluse]

That's right.

There is no missing text. Microsoft support is not right on this one.

However, I think in this case the problem might be something else, highlighted by this comment:
If you haven't included/referenced both files, that could possibly be the cause of the error.

Apparently I can only add the .xla as reference. It doesn't seem to accept the .dll.

[pointer27]

In the vba editor:

Tools>references
click on "browse" allow the browser window to show ALL files
go to: C:\Program Files\Microsoft Office\Office12\Library\SOLVER

add a reference to "SOLVER.XLAM"

This solved it for me, the problem seems to be Excel 2007. For some reason (as previously mentioned) you can't add SOLVER32.DLL