A
ar164ts
Friend wrote an Excel spreadsheet using the solver, written for a
multi-lingual version of Office. The language used is Italian.
They now want to distribute the spreadsheet to their own customers, wh
will be using the plain-vanilla version of Office (2000/XP).
Problem is, the worksheet will not run on machines with vanilla-Office
I have already changed:
a. solver functions from Italian to English eg
from: SOLVER.XLA'!RISOLUTORE.RISOLVI()
to: SOLVER.XLA'!SOLVER.SOLVE()
b. macro definition of solver location
from: C:\Program Files\Microsoft
Office\Office\LIBRARY\Risolut\SOLVER.XLA
to C:\Program Files\Microsoft Office\Office\LIBRARY\SOLVER.XLA
The error is still the same, "insufficient data"
If anyone has any pointers/solutions, would appreciate it very much.
Thanks
multi-lingual version of Office. The language used is Italian.
They now want to distribute the spreadsheet to their own customers, wh
will be using the plain-vanilla version of Office (2000/XP).
Problem is, the worksheet will not run on machines with vanilla-Office
I have already changed:
a. solver functions from Italian to English eg
from: SOLVER.XLA'!RISOLUTORE.RISOLVI()
to: SOLVER.XLA'!SOLVER.SOLVE()
b. macro definition of solver location
from: C:\Program Files\Microsoft
Office\Office\LIBRARY\Risolut\SOLVER.XLA
to C:\Program Files\Microsoft Office\Office\LIBRARY\SOLVER.XLA
The error is still the same, "insufficient data"
If anyone has any pointers/solutions, would appreciate it very much.
Thanks