| |
|
|
DEAFrontier TM
Microsoft® Excel Add-In
 The following
is for Excel 97, 2002 and 2003. The Excel Solver Parameters dialog box has to be displaced once before the DEAFrontier software is loaded. Otherwise, the DEAFrontier software may not run. (If the DEAFrontier software is installed in the directory where the Excel Solver is installed, you may not need to load the Excel Solver first.) However, for some non-English versions of Microsoft Office, DEAFrontier software may still produce an error message if one attempts to use the DEA models. This may due to the fact that the "Solver.xla" is renamed in a local language in the Microsoft Office. For example, in some Finnish versions of Microsoft Office, "Solver.xla" is actually named as "ratkais.xla". In order to use the DEAFrontier software, one has to make sure that the Excel Solver is named as "Solver.xla" in its directory (usually Program Files\Microsoft Office\Office 10\Library\Solver). If your Excel Solver file is named in your
language, here is how to resolve the problem: 1. Make a copy the *.xla file in its directory
and rename its as "solver.xla". Alternatively, one can use the File/Open
menu item to load the renamed Solver.xla manually from its directory.
In this way, one does not have to "remove & install" as described
above. One can also run the Excel Solver from other directory. This is actually what one has to do if one uses the licensed premium solver platform or equivalent software. Therefore, if one does not want to change the original installation, one can create a new directory and copy all the Excel Solver related files into this new directory and then follow the above steps. Finally, one can also use the VBA
window/tools/references to see if the English "Solver" appears (see
Figure 1.17 on page 20, Zhu (2002, Kluwer Academic Publishers)).
If so, one should be able to run
the DEAFrontier software.
|