LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 837
Default Solver won't open

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Solver [email protected] Excel Worksheet Functions 2 March 30th 08 09:37 PM
Solver Tiffany Excel Discussion (Misc queries) 0 October 15th 06 06:21 AM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Can solver do this? chrisrowe_cr Excel Worksheet Functions 2 July 14th 05 06:03 PM
Solver Jake Excel Discussion (Misc queries) 0 May 18th 05 10:20 PM


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"