I have created an Excel macro using the Solver add-in. When I tried to run it, it indicated a compile error: sub or function not defined. When I try to add a reference to the Solver add-in under Tools, Reference, it gives me an error saying "Can't perform requested operation".
Do you have any idea why it can't add a reference to Solver?
Do you have any idea why it can't add a reference to Solver?