Data Validation

The Data Validation appears when you click the Validate button:

When you click the checker window it will open and you will have an overview of the data, making it easier to find errors in the various worksheets:

Note that items with a background contain some kind of error. Then go to the item and look for cells whose value is red:

In the example above, the value are zeroed.