Set Scenario Cells to #Missing

You can set scenario cells to #Missing even if the corresponding base cells have values.

To set a scenario cell to #Missing:
  1. Type #Missing in the cell or delete the cell contents.
  2. Select Submit Data on the Smart View ribbon.
  1. Initially, the value in sb1 is an exact mirror of the value in the base.
    Image of a grid showing sb1 and Base, both with a value of 678.

  2. Enter #Missing in sb1 (or delete the cell contents) and submit data.
    Image of a grid with #Missing in sb1.

  3. Refresh the sheet. See that sb1 is #Missing.
    Image of a grid with #Missing in sb1.