Excel 2000 Solver AddIn: Model Load & Reset Have Excessive Delay

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Problem

While the Solver screen displays quickly, the loading of models and then resets take too much time
Approx. 60 seconds to load a small model, 30 seconds to reset
When called from macro these times almost double.

During this time the status bar is blank and Task Manager Processes and Performance show almost no load

Solving goes by very quickly. No complaint there

The Workbook is not shared, contains 12 worksheets
some of which contain ODBC data calls which do not seem to be refreshed, as I see no status or error messages
(And there should be error messages since some of the databases are offline, if they are being refreshed.

Again, everything works fine. I just want to fix the pause
It 'feels' like either the task is not getting a time slice
or some file permission problem.

System

(This behavior has been similar on other machines
Win XP Prof 2002 SP
Dell Optiplex GX11
Pentium 4 2.4 GH
512 MB RA
30 gig free on NTFS H

Processor scheduling & Memory usage
best performance for Program

Model

_____________________________Formulas in Cells $A$100:$A$11

=MIN($M$22
=COUNT($C$16,$C$18,$C$20,$C$21
=$C$16>
=$C$17
=$C$18>
=$C$19
=$C$20>
=$C$21>
=$C$22 10
=$M$22> $A$1
=$E$22 $A$1
=$G$22< $A$1
=$I$22< $A$1
=$J$22< $A$2
={100,100,0.000001,0.002,FALSE,FALSE,TRUE,1,1,2,0.0001,TRUE


Macro
__________________________________ VBA Code for Macr

Sub SolveModel(

' Keyboard Shortcut: Ctrl+

SolverRese
SolverLoad LoadArea:="$A$100:$A$114
SolverSolv

End Su

P.S. Would if be considered good form to add error checking to this macro

Many thanks for your time and any comment
Davi
 
The only thing I can think of at the moment that might cause an error is if
the "Load Area" is not the active sheet. I'm sure this is not your problem
though.

--
Dana DeLouis
= = = = = = = = = = = = = = = = =


<snip>
 
Dana

Thanks for responding. The "Load Area" is on the active sheet

But, strangely enough, I had been considering putting the models on a different sheet just to streamline the working area
I would have thought that if the macro called the model area with a fully qualified reference, that would work OK. Maybe I won't go there

As far as "causing an error"... so far I'm not getting any errors, just this annoying pause
If the CPU usage was high during the pause, I'd just chalk it up to overhead

Still hoping for insight
 
Back
Top