Solver Macro Error at Cell

[adamg33]

Hello,

I am running Solver from VBA.

Sometimes I get an 'Update values' dialog box, that asks to update values referring to the sheet that is currently open.

If I then click cancel, I get a message:

Macro error at cell:
[SOLVER.XLAM]Excel4Functions!A25

If I click continue, the macro runs as normal. Most of the time this error doesn't even come up. Really need some help on this.

 

[Suresh K Ramasamy]

I also faced this problem and got to this link via google - http://www.excelforum.com/excel-programming-vba-macros/555406-solved-solver-solversolve-showref.html. Changing the file name - removing spaces in my case - Sorted out this issue.