SSMSHEETSTATUS (System Variable)

Controls how the status data in a sheet set is refreshed.

Type:Integer
Saved in:Registry
Initial value:2

The status data for sheets in the current sheet set includes whether a sheet is locked and whether a sheet is missing (or found in an unexpected location). This status data can be updated automatically for all sheets.

To refresh the sheet set manually, use the Refresh Sheet Status button on the Sheet List tab of the Sheet Set Manager.

Value

Description

0

Do not automatically refresh the status data in a sheet set

1

Refresh the status data when the sheet set is loaded or updated

2

Refresh the status data when the sheet set is loaded or updated, or at a time interval set by SSMPOLLTIME