Updating Cell Data

The Update tab of the Cell Properties dialog box displays information about the cell value and enables you to update cell data, including annotations not available through the Direct Update functionality.

To update cell data:

1. In the Cell Properties dialog box , click the Update tab. The Update tab appears, enabling you to view information about the cell.
2. In the Value area, you can enter a new value for the cell. If the cell's value is the result of a calculation, you can leave the value as is, as it is automatically calculated. The value's data source is displayed to the right of the value. Data source refers to the manner in which data is input to the cells. Data can be input manually, calculated using a pre-defined function or imported from an external database. For more information about data sources, refer to Entering Data Source Information in Working with Categories. The current value of the cell is displayed to the left of the input field.
   • To report no value, type (-) in the Value field.
   • If you manually assign a value, the assigned value overrides any calculation methods that are assigned to the field.
3. In the Indicator area, you can select the required indicator symbol to be displayed in the cell. If a calculation method is assigned to the cell's indicator, you can leave the selection as is, and the symbol is automatically calculated. The calculation method for the indicator is displayed to the right of the indicator value. Data calculation refers to the manner in which data is input to the cells. Data can be input manually or calculated using a pre-defined function. For more information about data sources, refer to Entering Data Source Information in Working with Categories. The current indicator color is displayed to the left of the radio buttons.
   • To report no indicator, select No Indicator in the Indicator field.
   • If you manually select an indicator, this selection overrides any calculation methods that are assigned to the indicator.
4. In the As of area, specify a date as of which the new value is valid. If the cell has a schedule, the As of drop-down list includes both the current value, marked with an *, and the next scheduled update date. If the cell has no schedule, select any date from the drop-down calendar.

   Note:

   Cells with historic or future date definitions show the As of as read-only.

5. In the Annotations area, enter any required information about the current cell update.
   • The Reference area displays the reference category for the cell, if one exists. It is for viewing purposes only.
   • The Last Updated area displays when and by whom the cell was updated. The name of the user making the request and the name of the user responsible for updating the cell are displayed to the right.
   • To save changes, you must click the OK button.
   • Changes are not saved when moving between tabs. However, clicking OK on any tab saves changes made to all tabs.