Description
This video demonstration will introduce you how Incisive Validate monitors Excel's behavior of external workbook updates. We start this demonstration with a workbook called "simple_formulas" that references another workbook called "simple_external_data".

Cross Workbook Features of Validate

1. We start with two workbooks: One with a single formula called "simple_formulas" and one with a data cell called "simple_external_data".
2. We start with Validate already running and the formula's value marked as suspect (with an X).
3. Using the Fault Investigator, we can click to the data cell referenced by the formula.
4. After updating the data cell, Validate alerts us that our cell that was marked as suspect changed.
5. We can see that in the Validate History. Goto Selection will take us to the affected cell.
6. Now, we can approve the cell's new value.
7. You can watch more tutorials at Incisive.com

Further Information

• See a more advanced example of this feature in action at: Validate and External Reference Updates