what does this error message mean?

[novice_2010]

Hello, All

I tried to run a file (test.xlsm) using Excel 2010. I have enabled macro in the setting; however i got following error message:

cannot run the macro "solver.xlam!main". The macro may not be available in this workbook or all macros may be disabled

I am pretty sure I did not use solver in my macro; but what is "solver.xlam!main"?

I searched on line but couldn't find any error message like this.

Can anyone help?

 

[novice_2010]

By the way, I can run this file in Excel 2007.

 

[VoG]

Tools > References, tick Solver.

 

[novice_2010]

"Tools > References, tick Solver"

How do i do this in excel 2010?

 

[VoG]

Press ALT+ F11, select Tools, tick Solver

 

[novice_2010]

Thank you.

Unfortunately, I still get the same error message.