Edit a formula in Datasheet view

Microsoft Datasheet View

Edit a formula in Datasheet view

  1. Click any cell in the calculated column.
  2. Click the cell again to display the current formula.
  3. Edit the formula and press Enter.

    Note  After you type the equal sign (=) in a calculated column, you can paste a column reference simply by clicking the cell in that column that belongs to the current row. However, if the column is of a data type that does not support calculations, if you are attempting to select a cell in a different row, or select more than one cell, the list will not paste the column reference in the formula.

  4. Click Continue to confirm your changes.
  5. If there are pending changes, or conflicts and errors, in the list, you will be prompted to commit or discard your changes, conflicts, and errors. Changing a formula results in a change to the structure of the list, so the new formula can take affect only after all changes have been submitted to the server or discarded, and all conflicts and errors have been eliminated from the list.

    Click OK to commit changes, and resolve conflicts and errors.

  6. The list will send the pending changes to the server. If there are conflicts and errors, you will see the Resolve Conflicts and Errors dialog box. Accept or discard your changes.