2 Install Oracle Visual Builder Add-in for Excel

To install Oracle Visual Builder Add-in for Excel, you must download the vbafe-installer.exe installation file from the Downloads page.

You can install the add-in on Windows 10 operating systems that run the 32-bit version of Microsoft Excel 2016 or 365. Follow these steps to install the add-in afresh or upgrade an existing installation. If you're upgrading, make sure you follow the recommended practices (see Best Practices for an Upgrade).

1. Quit Excel before you begin installation.
2. Double-click the vbafe-installer.exe file that you downloaded previously to launch the installation wizard.
3. As a business user responsible for data entry, click Developer Options and select Disabled to exclude the designer tools and install only the tools that help manage data.
4. Click Install.
   
   
   Description of the illustration install_wizard.png
   
   
   The add-in requires the Microsoft .NET Framework and Visual Studio Tools for Office Runtime to be installed on your computer. If this software is not present, both are installed.

   Note:

   While administrator privileges are not required to install the add-in, you must have administrator privileges to successfully install Microsoft .NET Framework and Visual Studio Tools for Office Runtime. The add-in is installed for the current Windows user only.
5. Once installation is complete, click Close.

   If you run into issues, see Troubleshooting Your Installation.

6. 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
   
   

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. Make sure you have an Oracle.com account to sign in and download the new version.

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.

Best Practices for an Upgrade

To ensure a clean upgrade, follow these instructions when upgrading your installation of Oracle Visual Builder Add-in for Excel.

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 vbafe-installer.exe installer file for the new version. The installer will automatically replace 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.

Troubleshooting Your Installation

If you run into issues when installing the add-in, follow these steps to check your environment and troubleshoot issues:

1. Download and run the Visual Builder Add-in for Excel - Client Health Check Tool (see How to use Visual Builder Add-in for Excel - Client Health Check Tool (Doc ID 2477792.1)).
2. Check the %TEMP%\vbafe\vbafe-installer-log.txt installation log.
3. If the preceding steps don't work, disable and re-enable the add-in:
   1. In Excel, click File > Options > Add-Ins.
   2. Select COM Add-ins in the Manage drop-down list and click Go.
   3. Deselect the Oracle Visual Builder Add-in for Excel check box and click OK.
   4. Restart Excel.
   5. Follow steps a to d to enable the add-in.
   
   Description of the illustration disableaddin.png