Check Formula Tables

The Check Formula Tables integrity check tests the following rules for each formula table:

  • Variable, formula, and formula table in each cell is valid.
  • Row and column limits are in sequence from smallest to largest.
  • Row and column selectors are valid.

To check data integrity on formula tables:

  1. From the View group of the Home tab, click Integrity Checks.
  2. Select Check Formula Tables from the Integrity Checks list (left-hand pane).