Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins &
power4XL Black Scholes Options Toolkit Help
The following checklist addresses the
most common problems in installing and using power4XL functions.
If not, then follow these instructions.
To make sure the Analysis
ToolPak is installed, select Tools -
Add-Ins from the Excel menu. In the list of available
add-ins, make sure the box next to "Analysis ToolPak" is
checked. If it is not, then check it and click "OK".
This will install the add-in.
You may be required to close
Excel and restart it in order for the Analysis ToolPak to be
how your Excel was originally installed, you may be required
to insert your Microsoft Office Setup CD ROM for this
process to be completed.
If you have attempted the
above steps but the Analysis ToolPak has not been
successfully installed, please refer to your Microsoft
documentation or Microsoft's troubleshooting resources to
correct the problem.
more info on the Microsoft Excel Analysis ToolPak, see
On the Excel
menu, select Tools - Macro - Security. The Security Level
should be set to "Medium" or "Low". We recommend Medium.
If you are unable to change the
security setting, please check with your network
administrator, or refer to Microsoft's documentation and
troubleshooting resources to solve the problem.
Make sure that you
correctly copied & pasted the entire code segment into the
power4XL module in Visual Basic. Consider making a
clean start -- delete the code segment from your power4XL
module, download a fresh copy from this website, and repeat
the instructions for
installing a new function.
|If you have checked all of
the above and are still having trouble, please
send an email to let us know about it. While we
can't offer extensive technical support, we do want to know
of the problems people are having so that we can continue to
improve our site and support.
and all content, including computer code and spreadsheet examples, are copyright
2006 by Fritz Dooley.
License is granted for individual users to download examples and to copy code
directly into user's spreadsheets and Visual Basic for Applications files.
Users may not redistribute code in any way. Providing hyperlinks to this
web site is encouraged, but posting code and
examples on other web sites is expressly forbidden. "Microsoft" is a
registered trademark of Microsoft Corporation. Neither
this web site nor Fritz Dooley is affiliated
with Microsoft Corporation.