7 Troubleshoot Excel Workbooks

If you run into issues when working with integrated Excel workbooks, use the information in this section to identify and resolve issues with Oracle Visual Builder Add-in for Excel.

Before you dig deeper to isolate issues, follow these steps to fix general issues with your installation:
  • Make sure you're on a supported platform.
  • Upgrade to the latest version of the add-in.
  • Apply available Microsoft updates.
  • Close all workbooks, exit Excel, and try again with simple steps.

Check your Environment for Issues

Run the Client Health Check tool to determine if your environment is configured correctly.

Download the tool from My Oracle Support. For details on how to run the tool, see How to use Visual Builder Add-in for Excel - Client Health Check Tool (Doc ID 2477792.1)

Logging

When reporting an issue about the add-in, generate a detailed log file that captures the steps that lead to the problem you want to report.

  1. In Excel, click the Oracle Visual Builder tab.
  2. Select Log Activity from the Advanced drop-down list to specify a directory location and file name for the log file. This starts the logging session.
  3. Repeat the steps that lead to the issue.
  4. Exit Excel completely to stop the logging session and before you access the log file.

    Note:

    The next time you run Excel logging will no longer be enabled.

The log file that you generate captures information about steps during an Excel session.