Resolve Workbook Issues

If you see an error message when you open a workbook or find that some Oracle Visual Builder ribbon commands are disabled, Oracle Visual Builder Add-in for Excel has detected an issue with your workbook. Use the Workbook Info window to troubleshoot these issues.

Your workbook may be unusable for a number of reasons such as if it is marked as final in Excel or has been saved to an incompatible file type.

To check the status of your workbook, open the Workbook Info viewer by choosing Workbook Info from the Advanced menu of the Oracle Visual Builder ribbon. This viewer shows information such as the name, location, and status of your workbook.



Check the status for the description of the issue and for any troubleshooting steps. Issue-free workbooks have a status of "Integrated". Workbooks that are not integrated with the add-in will show a status of "Not integrated".

In a scenario where a workbook is marked as "final", you'll need to clear the Mark as Final setting (under File>Info>Protect Workbook), then save and reopen the workbook.

Note:

Do not use Excel's Edit Anyway button in the yellow message bar to try to edit the workbook. This command will not re-enable the Oracle Visual Builder ribbon.