Credit Risk Modeling Using Excel and VBA with DVD

Some Hints for Troubleshooting

We hope that you do not encounter problems when working with the spreadsheets, macros and functions developed in this book. If you do, you may want to consider the following possible reasons for trouble:

• We repeatedly use the Excel Solver. This may cause problems if the Solver Add-in is not activated in Excel and VBA. Howthis can be done is described in Appendix A2. Apparently, differences in Excel versions can also lead to situations in which a macro calling the Solver does not run even though the reference to the Solver is set.
• In Chapters 10 and 11, we use functions from the AnalysisToolpak Add-in. Again, this has to be activated. See Chapter 10 for details.
• Some Excel 2003 functions (e.g., BINOMDIST or CRITBINOM) have been changed relative to earlier Excel versions. We've tested our programs on Excel 2003 and Excel 2010. If you're using an older Excel version, these functions might return error values in some cases.
• All functions have been tested for the demonstrated purpose only. We have not strived to make them so general that they work for most purposes one can think of. For example:
  • some functions assume that the data is sorted in some way, or arranged in columns rather than in rows;
  • some functions assume that the argument is a range, not an array. See Appendix A1 for detailed instructions on troubleshooting this issue.

A comprehensive list of all functions (Excel's and user-defined) together with full syntax and a short description can ...