Update worksheet data

Update input columns

Input column changes are instantly copied to the corresponding primary data source in the Zilliant cloud. These changes immediately ripple into your other Zilliant products and third-party systems that are integrated with your Zilliant data sources.

Update input columns by:

• Directly overwriting values
• Making simple additive or subtractive changes
• Applying a formulaic bulk update

Directly overwrite a cell value

1. Double-click any cell in the input column.
2. Enter a new value.
3. Select the Return/Enter key or click anywhere else in the worksheet to commit the change.

Make simple additive or subtractive changes to existing column values

1. Select one or more cells, then select Edit.
2. Enter the number or percentage amount to increase or decrease the existing cell value.
   Tip

   To decrease the existing cell value, enter a - (minus sign) in front of the amount.

3. Select Save.

Apply a formulaic bulk update to existing column values

1. Next to an input column heading, select ⌄, then select Update to open the Update column value dialog.
2. In the Update definition field, enter a formula expression.
   Tip

   You can use formula syntax described in About formula expressions.

3. Decide which rows to update:
   • To update all rows in the worksheet, clear the Use current filters option and leave the Filters section empty.
   • To update only currently visible rows (if you prefiltered the worksheet), select the Use current filters checkbox.
   • To ignore current filters (if you preapplied any) and update rows according to a different set of filters, add at least one filter in the Filters section and clear the Use current filters checkbox.
4. Select Update.

Update related columns

Related columns are read-only. You cannot update their values directly.

To update a related column, find a worksheet that uses the same column as an input column. Updates to the input column are duplicated in the related column.

Update calculated columns

Calculated columns are read-only. You cannot update their values directly.

To update a calculated column, update the input and related columns that are used in the calculation.

Copy and paste worksheet rows

1. Right-click a row, then select Copy Record.
   Note

   If you don't see this option, select Properties. On the Worksheet General Properties page, select the Copy Rows checkbox.

2. In the Insert Row dialog, update cell values.
3. Click Save to paste the copied row into the worksheet.