Excel - @RISK add-in

Asked By Jacly on 08-Jun-07 11:15 AM
I am using Excel 2003, trying to load Palisade software, specifically @RISK.
It is an add-in for excel.  The installation process proceeds fine.  but when
I try to open the program, excel opens and shows the error message "Could not
load athlib32.dll".

I am using Windows Vista.  I know other people in my class have loaded this
program just fine in other versions of Windows.  Please help.  I don't know
what to do!

Thank you.




Peo Sjoblom replied on 08-Jun-07 11:30 AM
Have you contacted Palisade software?


--
Regards,

Peo Sjoblom
Jacly replied on 08-Jun-07 11:41 AM
You can only get tech support if you register.  In order to register, during
the registration process you must check off what type of software you have
installed.  There are several different versions, and since I can't open up
the software once it is installed, I can't tell what version I am using.
Also, this is a student installation package, and no version information is
listed on the packaging.
Peo Sjoblom replied on 08-Jun-07 11:57 AM
http://helpdesk.palisade.com/kb/

type in or paste

Could Not Load ATHLIB32.DLL

in the search box and select @RISK for Excel in the Product dropdown

the problem solution was as follows:


This message can occur when the reference to DTOOLS32.xll in the Excel
Add-Ins dialog (and thus in the Windows Registry) is no longer valid. For
example, if two different editions (such as Standard and Professional) or
two different versions (such as 3.5 and 4) of @RISK for Excel are installed
on the same machine, this could happen when the current DTOOLS.ini file
points to a different DTOOLS\System folder.

If you know for a fact that 2 different editions are not, and have never
been installed on that machine, try the following:

1) Open Excel and access the TOOLS > ADDINS dialog

2) Un-check the "DTOOLS32"

3) If you get a message stating that the Dtools32.xll no longer exists in
the specified location, choose to have it removed from the addins list

4) Access the TOOLS > ADDINS dialog again and using the "BROWSE" button
navigate to the "..\Dtools\System\Dtools32.xll" and add it to the list of
addins leaving it checked.

5) Close Excel, then restart @RISK.

The message can also occur if the DTOOLS folder has been renamed or moved so
that the DTOOLS.ini no longer points to the appropriate location.

There is an alternate message sometimes caused by these conditions: Could
not load RSKLIB32.DLL.

To fix this problem re-install the software to re-establish the correct
program path settings."
Jacly replied on 08-Jun-07 02:25 PM
Thank you, but this did not solve the problem.  And I gathered some
additional information...
1. I have an additional error message:  "Could not load C:\Program
Files\Palisade\SYSTEM\ATHLIB32.DLL, err=1114."
2. I searched my computer and I can't find any folder named DTOOLS.
3. I found the DTOOLS.INI file.  The file content is below...

[EXCEL]
EXCEL32=C:\Program Files\Microsoft Office\OFFICE11
EXCELEXE=EXCEL.EXE
[DIRECTORIES]
TEMP=C:\Windows\TEMP
RANK32=C:\Program Files\Palisade\RANK32
DTOOLS=C:\Program Files\Palisade
SYSTEM=C:\Program Files\Palisade\SYSTEM
[REGISTRATION]
TOPRANK=BOOK
[TOPRANK DEFAULTS]
max_sens_vars=10000
max_listed_vars=10000
max_output_vars=10000
insert_autovary_functions=1
default_minus_range=10
default_plus_range=10
default_range_type=0
default_distribution=Uniform
default_steps=4
default_multi_steps=2
multi_groupsize=2
[INSTALL INFO]
RANK32=REGULAR
Jacly replied on 08-Jun-07 02:43 PM
Also, I tried to edit and resave the DTOOLS.INI file and I got the following
error message:  "Cannot create the C:\Windows\DTOOLS.INI file.  Make sure
that the path and file name are correct."
Stan Brown replied on 08-Jun-07 10:10 PM
Fri, 8 Jun 2007 08:15:00 -0700 from Jaclyn

http://helpdesk.palisade.com/kb/article.asp?ID=446

If that doesn't do the trick, try an email or call to Palisade.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Jacly replied on 09-Jun-07 11:01 AM
This is the same as the first suggestion.
Gail Richner replied on 22-Jun-07 12:53 PM
If you still do not have this resolved, you really need to contact Palisade
for support
Kami replied on 09-Jul-07 10:04 AM
Jaclyn,

I had the exact same issue you had and finally figured out a way to
resolve it.  Go to the following link and download an update to the
software:

http://www.palisade.com/Updates/dts45_update.asp

Once you install it, Decision Tools should work without a problem.

Kami