Configure the data connection for Schedule

In Excel, click Options in the Setup group of the AVEVA™ USC Schedule ribbon tab.

To configure a connection to a remote staging server:

1. Click the Web Server option.

2. Enter the Server Url in the text box. You do not need to include /send.ashx in the address, and is ignored if included.

3. If needed, enter a custom Timeout value in seconds. This is the maximum number of seconds the Excel Add-In will wait for a reply to a request sent to the Web server. You should have to change this field only to correct timeout problems with a server, for example increasing the timeout limit to allow a slow server to respond.

   The timeout value must be greater than zero, and is set to its default value of 300 seconds until you enter a custom value. If you enter a timeout value of zero, it is reset to its default value the next time you open the Configuration dialog.

4. Configure your authentication method:

   • To access the Web server with the same credentials as your current Windows account, click Windows Authentication and select the Use Integrated Security check box. To use a different set of credentials, clear the check box and enter the User Name and Password in the text fields.

   • To authenticate via CONNECT, click AVEVA Connect and then Sign In. The CONNECT sign in window opens, where you can enter your credentials.

5. Click OK.

Once you have configured the data connection, you can import data into your Excel workbook.

Configure the time zone

You can convert all times in the data for a time zone of your choosing. Note that this option affects how data are displayed, not the underlying values.

To convert times to a particular time zone, select an option from the Time Zone list in the Setup group of the AVEVA™ USC Schedule ribbon tab. Select the Automatically adjust for Daylight Saving Time check box if you want the conversion to keep into account the Daylight Saving Time period for the time zone you have chosen.