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.

Example

1. Initially, the value in sb1 is an exact mirror of the value in the base.
   
   

2. Enter #Missing in sb1 (or delete the cell contents) and submit data.
   
   

3. Refresh the sheet. See that sb1 is #Missing.