Fusion: Configuring Excel to work with ADF Desktop Integration

You must configure Microsoft Excel settings to make it accessible from ADF Desktop Integration. You only need to perform this procedure once.

To allow Excel to run an integrated Excel workbook:

1. Open Excel.
2. Click the Microsoft Office button, and choose Excel Options.
3. In the Excel Options dialog, choose the Trust Center tab, and then click Trust Center Settings.
4. In the Trust Center dialog, choose the Macro Settings tab, and then click the Trust access to the VBA project object model checkbox, as shown in Figure.
   Figure 3-1 Excel Trust Center Dialog

   
   

   
5. Click OK.                                                                                                                                        -------------------------------------
 

To install the Designer edition of ADF Desktop Integration:

1. Open JDeveloper.
2. From the Tools menu, choose Install ADF Desktop Integration, as shown in Figure.
   Figure 3-2 Tools Menu in JDeveloper

    
    
   Note: The Install ADF Desktop Integration menu option is available only on the Windows installation of JDeveloper.
3. Follow the instructions that appear in the dialog boxes to successfully install the required components
   If you encounter an error during the installation process, ensure that you have removed the previous version of ADF Desktop Integration.
4. If prompted, click Yes to restart the system and complete the setup of ADF Desktop Integration

Note: You can also install the Designer edition of ADF Desktop Integration by running setup.exe available in the MW_HOME\jdeveloper\adfdi\bin\excel\addin\designerdirectory.