Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Under what conditions will the solver dialog fail to open in Excel 2003
(11.8220.8132 SP2)? When I click on the (active) Solver menu entry, nothing happens -- no solver dialog, no error dialog; nothing. The interface is not frozen, since I can still navigate, enter formulas, etc. My workbook has 2 populated sheets (~410 populated cells per sheet). 33 cells per sheet (column A) pull values from another workbook (not open and links not updated) using the SMALL function. The remainder of the cells use relatively uncomplicated non-array formulas, alhough most cells use a well vetted VBA function from an .XLA within an IF function, and have conditional formatting, of which one condition calls a local VBA function. All formulas and conditional formatting appear to be working properly; The inability to start Solver is the only indication of a problem. I have saved the file and rebooted the system with no improvement. If I close that workbook and open a new workbook in the same session then Solver will open. Unless someone recognizes the situation, my next step will be to rebuild the workbook from scratch to see if it was somehow corrupted. Jerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Solver | Excel Worksheet Functions | |||
Solver | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Can solver do this? | Excel Worksheet Functions | |||
Solver | Excel Discussion (Misc queries) |