Disable or Enable Formula Calculations

Disabling calculations effectively halt the various Spreadsheet Server formula calculations in Excel spreadsheets. As a result, GXD and GEXQ formulas will return the SS Not Connected value and GXL formulas will return 0. If calculations are disabled, Spreadsheet Server cannot communicate with the host.

Disabling Spreadsheet Server formula calculations is useful:

• For discontinuing the calculation of a complex or long-running spreadsheet.
• If a workbook with the calculation option set to automatic is opened.
• If creating a new worksheet, or modifying an existing worksheet by adding columns and/or rows with Spreadsheet Server formulas, and switching a format to or from the range type period.

Disable Formula Calculations

In Excel, from the Spreadsheet Server Ribbon, select Enabled, or, click the drop-down list, then Disable, or, click Tools > Disconnect All Open Connections. The system then disconnects from the host.

Enable Formula Calculations

1. In Excel, from the Spreadsheet Server Ribbon, select Disabled, or, click the drop-down list, then Enable. The sign in dialog box appears, based on the selected ledger.

Note: For Data Warehouse and most Designer GL ledgers, no dialog box appears.

2. Type your sign in credentials and click OK.

Note: If unattended (auto) sign in is enabled, this step is not applicable.

Use the following links to access ledger-specific sign in information:

• Analyst
• BPCS 4.05
• BPCS 6.02
• BPCS 6.04
• Data Warehouse
• Designer GL
• Infinium
• Jack Henry 20/20
• Jack Henry Silverlake
• JD Edwards
• Lawson
• Movex
• Oracle
• PeopleSoft
• SAP