Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Solver, Answer Report
I Keep getting an error when I try to create an answer report after running
solver. Solver finds a solution, when I keep solution and click answer report it gives me an error report ( unexpected internal error). Can anyone help? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Solver, Answer Report
Hi,
What exactly is the entire error message? What version of Excel are you running? When you get the message what are the options? And when you pick an option what happens? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Joey" wrote: I Keep getting an error when I try to create an answer report after running solver. Solver finds a solution, when I keep solution and click answer report it gives me an error report ( unexpected internal error). Can anyone help? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Solver, Answer Report
I am running Excel 2007, there are no options, it tells me there has been an
unexpected internal error occured, or available memory has been exhausted. Thanks "Shane Devenshire" wrote: Hi, What exactly is the entire error message? What version of Excel are you running? When you get the message what are the options? And when you pick an option what happens? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Joey" wrote: I Keep getting an error when I try to create an answer report after running solver. Solver finds a solution, when I keep solution and click answer report it gives me an error report ( unexpected internal error). Can anyone help? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Solver, Answer Report
Hi. Just guessing here. Do you have any active x controls on your
sheet? If so, try removing them and see what happens. = = = Dana DeLouis Joey wrote: I Keep getting an error when I try to create an answer report after running solver. Solver finds a solution, when I keep solution and click answer report it gives me an error report ( unexpected internal error). Can anyone help? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi. Just guessing here. Do you have any active x controls on yoursheet?
I had similar issues when using ActiveX controls. You need to strip engineer a way for the solver to bypass all the resulting solutions.
-Conner http://www.oneclickcommissions.com/excel-reports.html On Saturday, February 21, 2009 8:34 AM Joe wrote: I Keep getting an error when I try to create an answer report after running solver. Solver finds a solution, when I keep solution and click answer report it gives me an error report ( unexpected internal error). Can anyone help? Thanks On Saturday, February 21, 2009 11:52 AM ShaneDevenshir wrote: Hi, What exactly is the entire error message? What version of Excel are you running? When you get the message what are the options? And when you pick an option what happens? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Joey" wrote: On Saturday, February 21, 2009 12:28 PM Joe wrote: I am running Excel 2007, there are no options, it tells me there has been an unexpected internal error occured, or available memory has been exhausted. Thanks "Shane Devenshire" wrote: On Saturday, February 21, 2009 12:32 PM Dana DeLouis wrote: Hi. Just guessing here. Do you have any active x controls on your sheet? If so, try removing them and see what happens. = = = Dana DeLouis Joey wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Solver Internal Error When Generating Answer Report | Excel Discussion (Misc queries) | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
Exel 2003, Solver,"Answer" inactive. | Excel Discussion (Misc queries) | |||
Solver returns non binary answer in binary constrained cells | Excel Worksheet Functions | |||
Excel solver sensitivity report has empty shadow prices column? | Excel Discussion (Misc queries) |