Oracle Sign In

Follow the below steps to start the add-in component of Spreadsheet Server for Oracle ledgers:

1. Open Excel.
2. In Excel, from the Spreadsheet Server Ribbon, select Disabled (or, click the down arrow under the Disabled button, and click Enable). The Login dialog box appears.


3. Two methods are available for signing into Spreadsheet Server:

Direct Connect

In the Login: dialog box, specify the following fields:

• Select the Direct check box.
• Host: the system name or IP address that hosts the database.
• Service: retrieves the Oracle Service Name from Application Configurator, indicating where the database is located.
• Port: retrieves the port number assigned to the service in Application Configurator.
• User Name: defaults to the user name assigned to the user in Application Configurator.
• Password: required only if a password was created for the user in Application Configurator.

Oracle Client

In the Login: dialog box, specify the following fields:

• Oracle Service Name - the Oracle Service Name configured in Oracle Net Manager.
• User Name: defaults to the user name assigned to the user in Application Configurator.
• Password: required only if a password was created for the user in Application Configurator.
4. Click Login. The Oracle Default Responsibility panel appears, displaying the previously-selected responsibility.

5. Click on the drop-down list to select a different responsibility.
6. Click Continue.

See Sign In, Control Panel, Disable or Enable Formula Calculations, and Reset Host Server Connection for more information.