Troubleshoot Excel Workbooks

If you experience issues with Oracle Visual Builder Add-in for Excel, complete the first steps before proceeding to the relevant troubleshooting topics in this chapter.

First Steps

1. Upgrade to the latest version of the add-in and retry the scenario.
2. Make sure you're on a supported platform.
3. Focus on a single issue, generally the first or earliest one in the steps.
4. Identify clear steps and a problem statement.
5. Review the known issues in the documentation for the features being used.

6. Apply available Microsoft updates for Windows and Excel.

   Note: For more information about Excel, see Excel specifications and limits.

7. Close all workbooks, exit Excel, and try again with simple steps.

Problem Types

Determine the problem type before choosing the next steps:

• Add-in installation issues
  • The installation failed with an error message
  • The add-in is missing in Excel
• Login failures
  • OAuth2 and IAM
• Errors from the service
  • (401) Unauthorized
  • (403) Forbidden
  • (400) Bad Request
  • (500) Internal Server Error
  • (404) Not Found
• List of Values errors
• Network errors
  • 504 Gateway Timeout
• Add-in errors
  • Validation failures
  • Unable to load and analyze the service metadata
  • Invalid Expressions
  • Unexpected Errors
  • Disabled Workbooks
  • Create is not enabled for a child layout
• Getting More Help
  • Filing Service Requests
  • REST Service Teams
  • Cloud Customer Connect
• Postman vs. Network Monitor

Note: If download fails with a 400 response, review Status Viewer and Network Monitor details first. Invalid or incomplete search, finder, or download-parameter values are common causes.