2 Install Oracle Visual Builder Add-in for Excel

To install Oracle Visual Builder Add-in for Excel, download the Current User installer (vbafe-installer.exe) from the Oracle Downloads page and run the wizard.

You don’t need elevated privileges to install the add-in. However, if your system is missing required software, the installer will launch the required Microsoft Installers to install the missing components. These installers may require elevated privileges. Contact your network administrator for assistance if required.

Make sure that the proxy settings for Internet Explorer are configured to allow access to "*.microsoft.com". The installer may need to access Microsoft's website to download missing components.

This installation is specific to the current Windows user profile. If multiple users on a Windows machine need the add-in, each of them must log in to their profile and run the installer in order to use the add-in.

Note:

Refer to the Installation section in the Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel for more information.

1. Quit Excel before you begin installation.
2. Double-click the vbafe-installer.exe file that you downloaded previously to launch the installation wizard.
   The add-in includes a full set of commands for designing layouts, publishing workbooks, and more. If you don't need these tools, you can install the add-in without them.
3. Click Developer Options and select Disabled.

   Tip:

   If you need these tools after initial installation, re-run the installer, choose the option to repair your installation, and select Enabled.
4. Click Install.
   
   
   Description of the illustration install_wizard.png
   
   
5. The add-in requires the Microsoft .NET Framework and Visual Studio Tools for Office Runtime on your computer. If these components are missing, you are prompted to install them.

   Note:

   You must have elevated privileges to install Microsoft .NET Framework and Visual Studio Tools for Office Runtime.
6. Once installation is complete, click Close.
7. Start Excel and open a new workbook.

   A new Oracle Visual Builder ribbon tab appears, with commands that help you download and manage data from a web application.

   
   

   
   Description of the illustration ribbontab-user.png

   
   

   When you first run Excel after the current-user installation, you may be prompted to confirm the installation of the "Office customization". This prompt generally appears the first time for each profile and whenever the digital certificate (used to sign the add-in) is changed.

Check for Updates

It's a good idea to periodically check whether a newer version of the add-in is available for you to install. The latest version of the add-in is posted to the Downloads page.

1. From the Advanced drop-down in your existing installation, select Check for Updates.
   
   Description of the illustration check-updates.png
   
2. If a newer version is available, when prompted to open the downloads page in your browser, click Yes.
3. Download the installer for the latest version, then install the update. Before you update, be sure to review best practices as described in the next section.

Upgrade to the Latest Version

To take advantage of all the latest Oracle Visual Builder Add-in for Excel features, make sure you are running an up-to-date version of the add-in. To upgrade to a new version, simply download and run the installer.

You do not need to uninstall the previous version unless the installer instructs you to do so.

To ensure a clean upgrade, follow these instructions when upgrading your installation.

1. Before you upgrade the add-in:
   1. Upload any pending changes using the current add-in version.
   2. Save changes in open workbooks, then close Excel.
2. Run the installer for the new version and follow the instructions in the wizard. The installer automatically replaces the previous version with the new version.
3. After you upgrade:
   1. Launch Excel to complete any final installation steps.
   2. Open your integrated workbook.
   3. Clear any layouts of old data and download data again as required.