PeopleSoft Sign In

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

Note:

If a user's Spreadsheet Server Settings are set to start Spreadsheet Server during Excel startup, step 2 is not applicable.
If unattended (auto) sign in is enabled, steps 3 and 4 are not applicable.

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

Various methods are available for signing into Spreadsheet Server, based on the connection protocol being used:

SQL Server or DSN

In the Sign On to Spreadsheet Server dialog box, specify the following fields:

Host Name or IP Address: the system name or IP address that hosts the database.
Database Library: the name of library or catalog containing the GL data.
DSN Name: the name of the DSN connection.
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 Direct Connect

In the Sign On to Spreadsheet Server dialog box, specify the following fields:

Select the Direct check box.
Host Name or IP Address: the system name or IP address that hosts the database.
Service: the Oracle Service Name indicating where the database is located.
Port: the port number.
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 Sign On to Spreadsheet Server dialog box, specify the following fields:

Oracle Service Name: the Oracle Service Name configured through 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.