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-current-user.msi) from the Oracle Downloads page and run the installer.

If any required software is missing, the installation terminates without installing the add-in. Refer to Software Dependencies in Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel for details including information on how to check for and install required components. You can also refer to this topic for information on installing the Microsoft Edge WebView2 embedded browser. WebView2 is an optional Microsoft component and must be installed separately.

This installation is specific to the current Windows user profile. If multiple users on a Windows machine need the add-in, consider using the All Users installer instead. See Install Using the All Users Installer in Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel.

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

Note:

Running both installers on the same machine is not recommended. If you do install the add-in using both installers, Excel loads the add-in installed in the Program Files folder ("All Users") and not the version in the current user’s Windows profile ("Current User"). If you decide to switch the installation type, the best practice is to uninstall the previous add-in installation type first to avoid confusion.

1. Quit Excel before you begin installation.
2. Double-click the vbafe-installer-current-user.msi file that you downloaded previously to launch the installation wizard.
3. To install the add-in without the available developer tools, 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 to install the add-in.
   When the installation is complete, click Close.
5. 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.

For recommendations on when you should upgrade, check the Upgrade Policy in Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel.

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.