-
You will need Microsoft Excel
97 or later installed on your computer;
however some early versions of Excel 97 may not work properly.
If you do not know the version of Excel you have on the computer
do the following;
-
Start
Excel
-
Click
on Help on the
top Menu in Excel
-
On the
drop down menu, click on About Excel
-
On the
popup window the top line should have the version of Excel
on your computer.
-
Click
on OK
-
In Excel 2000 or later you
need to have the Security Level
set to Medium or Low. If you are not sure about your settings do the
following;
If you know your version of Excel you can set the
security settings automatically by following the instructions
below or set it manually.
2000 (aka 09)
2002 (aka XP or 10)
2003 (aka 11)
-
A File Download - Security Window
will pop-up
-
Click on the
Run button
-
A popup window
will ask you to confirm that you want to add the information to
the registry.
-
Click
Yes.
-
Another popup
window will confirm that the registry was updated successfully.
-
Click
OK.
You are now
ready to use the calculator.
If the
calculator does not work properly after setting the Security
Settings automatically, close Excel, then
Set the security
settings manually
-
Start
Excel
-
Click
on Tools on the Menu bar.
-
On the
drop-down menu go to Macro
then on the pop-out menu click on
Security.
-
Click
on the Security Level tab if it is not already selected.
-
If the
Security Level is set at High, select either Medium
or Low.
However I would suggest you select Medium. It is much safer than Low.
Then you
will have the option to enable Macros when needed.
-
Click
on OK once your selection has been made
and Close Excel.
IF YOU
CLICK ON THE LINK TO THE CALCULATOR WITH THE SECURITY SETTINGS ON HIGH, THE
PROGRAM WILL NOT WORK.
- To start
the program, click on the Calculator link.
-
If you
get a File Download window, click on the Open button.
-
If you
have your Security Level set to Medium, a Microsoft Excel window will pop-up,
click on the Enable Macros button.
-
If you start the
calculator from a dial-up phone, it will be slow loading and may
take several minutes to start.
Continue to the Calculator