Frequently Asked Questions

Navigation:  General Information >

Frequently Asked Questions

Previous pageReturn to chapter overviewNext page

 

How can I automatically load FinOptions XL every time I start Excel?

The installation should correctly install the Excel Add-in upon completion, but if there are issues please follow the steps outlined below.

1.Start Excel, click Tools\Add-ins on the menu bar.

2.Select Browse and navigate to the directory where FinOptions XL was installed. The default directory is C:\Program Files\Derivicom\FinOptions XL.

3.Once in this directory, select the file FinOptions.xla and press OK.

4.Once FinOptions XL has been installed, you will see Derivicom as a new menu bar item.

 

When I tried to load the sample workbook I got a series of error messages followed by a #NAME in most of the cells. What went wrong and how can I fix this problem?

The Excel Add-in, by default, is installed in the "C:\Program Files\Derivicom\FinOptions XL" directory along with the sample workbook. If the sample workbook and Add-in were moved to separate directories, you will receive this error.

 

To fix it, follow the steps outlined below.

1.Unprotect each worksheet. To unprotect each, select the sheet and click Tools/Protection/Unprotect Sheet from the menu bar.

2.Click Edit\Links on the menu bar to launch the Link Editor.

3.Select Change Source and navigate to the directory where FinOptions XL is located and press OK.

 

The sample workbook template is write-protected. What is the password?

The workbook is write-protected to guard against accidental modification. It is not password protected. There is no password associated with each sheet. To unprotect each sheet click Tools/Protection/Unprotect Sheet on the menu bar.

 

 

For the latest FAQ’s please see our website.