Troubleshoot Scenarios with Spreadsheet Add-ins

Describes scenarios for identifying issues while using Spreadsheet Add-ins and suggests corrective steps.

Spreadsheet Add-ins support the latest versions of Apple Safari, Google Chrome, Microsoft Edge, and Mozilla Firefox.

Note:

The steps or options in these scenarios might vary depending on the operating system and Microsoft Excel version. Contact your IT or system administrator for assistance.

When contacting Oracle Support for an issue, export logs from Settings and share them with the support team. Review the log file and secure any personal information or sensitive data before sharing it. See Manage Settings.

Scenario

The Add-ins icon on the Home tab is grayed out or disabled.

Suggestion

1. In an Excel workbook, go to File > Account. Under Account Privacy click Manage Settings.

2. Verify that the Turn on optional connected experiences option is selected. Close the Privacy Settings window.

3. From the File menu select Options > Trust Center. Click Trust Center Settings and go to Add-ins tab.

4. Verify that Disable all Application Add-ins is not selected. Deselect this option if already selected.

   Do not close the Trust Center window.

5. Go to the Trusted Add-in Catalogs tab in the Trust Center window.

6. Deselect the option Don't allow any web add-ins to start if already selected.

Verify that the Add-ins option is enabled.

Scenario

Why does the sign-in page in Add-in for Excel fail to load or is inaccessible?

Suggestion

• Check the compatibility version of Excel and the operating system.

• Check for any pending updates for Windows, Microsoft Office, or the web browser.

1. Open Windows Settings from the Start menu or press Windows + I on the keyboard.

2. On the Windows Update tab check for updates. If updates are available, review and install as required.

Scenario

The add-in does not work correctly after reinstalling.

Suggestion

Verify the configuration under Trusted Add-in Catalogs.

1. In an Excel workbook, from the File menu select Options > Trust Center.

2. Click Trust Center Settings and go to Trusted Add-in Catalogs tab.

   
   
   
   Description of the illustration adp-trusted-catalogs.png
   
   

3. Verify that the shared manifest folder path shows the correct location.

   Note:

   This set up is required only one time when you run the add-in installer or if the shared manifest folder is changed. The catalog address might change after the add-in removal and reinstallation for pointing to a new database.

   To remove the existing catalog and add a new catalog:

   1. From the Trusted Catalog Table select the catalog you want to remove and click Remove.

   2. Enter the new path of the shared manifest folder in the Catalog URL field and click Add catalog to add the shared folder to Trusted Catalog.

Restart the Excel application to apply the changes and to access Spreadsheet Add-ins.

Scenario

The add-in does not work even after configuring Trusted Add-in Catalogs in Excel.

Suggestion

Sometimes the database server changes are not reflected in Excel even after you set the correct path of the shared manifest folder in Trusted Add-in Catalogs.

To fix this:

1. Clear the Microsoft Office cache to unload Add-in for Excel

   See Clear the Office cache.

2. Reinstall the add-in and verify the configuration under Trusted Add-in Catalogs.

Scenario

The Add-ins icon is missing in Excel. What to do?

Suggestion

Follow these instructions to manually insert the add-in icon in Excel.

1. From the File menu select Options > Customize Ribbon.

2. Click New Group to add a new menu item under the Insert menu. You can click Rename and specify a name for the newly created menu, for example, My Addin.

3. In Choose commands from select All Commands.

4. Select My Add-ins [Insert an Add-in] from the All Commands list and click Add >> or Insert to add it to the newly created menu My Addin.

   Click OK to apply the changes.

   
   
   
   Description of the illustration add-troubleshoot1.png
   
   

5. From the Insert menu click My Add-ins to view Oracle Database Add-in for Microsoft Excel.

Scenario

You cannot view the changes updated in the latest version of the add-in.

Suggestion

1. On the Home tab select Add-ins and click Get Add-ins or More Add-ins depending on the Microsoft Office version.

2. On the Office Add-ins window go to the SHARED FOLDER tab.

3. Click Refresh.

   
   
   
   Description of the illustration refresh-folder.png
   
   

   The window displays a message - My Add-ins refreshed or updated.

The Refresh button reloads the manifest file for the latest changes to appear.

Scenario

OCI IAM login fails even though the connection configuration is correct.

Suggestion

Verify that the required ORDS role is enabled. Starting with ORDS 26.1.1, ORDS roles are disabled by default. Configure the required role before logging in using OCI IAM authentication. See Set up Role-Based Access Control Automatically using a Script.