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
• Download succeeds but no expected rows are returned
• 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.

Download Succeeds but No Expected Rows Are Returned

If a download completes successfully but no rows appear in the workbook, the REST service may have returned an empty result set. This can happen even when the request is valid and the add-in reports no error.

First, confirm that the explicit workbook criteria are correct. Search values, row finder values, download parameters, workbook parameters, or other configured filters may exclude all available rows. If appropriate, clear or broaden the criteria and try the download again.

If the workbook criteria look correct, use Network Monitor to inspect the download request and response. Confirm that the request URL contains the expected search, finder, and parameter values.

If the response is successful but contains no rows, the add-in has no additional information about why the service returned an empty result. Possible causes include service-defined filters, data access policies, roles, privileges, or user context that cause the service to return only the rows the current user is allowed to see.

Contact the REST service owner or system administrator. Ask them to verify the service’s data access rules, built-in filters, and the current user’s roles, privileges, and data assignments. Oracle Visual Builder Add-in for Excel cannot determine whether the service returned no rows because no matching data exists or because service-side filters excluded the data.