Using Solver in Browser

N

Naveen

I have an excel spreadsheet in which I am able to use the
solver without any problem. I have done the following:
- Defined the solver problem
- References SOLVER.XLA in the VBA editor
- Created a macro (as well as VBA procedure) whichloads
the solver, and solves the problem
- Created a toolbar with button to invoke the Macro
- Created a button on spreadsheet to invoke the VBA code

All this works fine when the spreadsheet is opened though
MS Excel.

The problem arises when this spreadsheet in opened in IE.
When the toolbar button (or a button on spreadsheet) I get
the following error.

Solver: An internal error occured or available memory was
exhausted.

I believe that this is because of SOLVER.XLA add-in. ANy
suggestions on how to fix this.

Thanks and Regards,
Naveen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top