Running Tests
The tests can be run either manually or automatically. They cannot be run on shared workbooks or workbooks whose structure is protected.
To run the tests manually, use the command XLSior > Test > Run Tests.
The tests can be run automatically whenever any of the following events occur:
See the sections on User preferences and Workbook preferences for details.
The way in which the tests are run does not affect what happens.
First, all test sheets (those whose names start with X~Test) are unprotected. You will be asked for passwords if they are needed. These sheets will remain unprotected after the tests have been run.
Next, all the test definitions are read. A progress indicator shows what is going on. This stage may be slow if there are many tests. You may cancel the tests at any time by clicking the Cancel button on the progress indicator.
As the tests are read, any sheets on which substitutions are to be made will be unprotected. You will be asked for passwords if they are needed. However, import sheets (those whose names begin with X~Imp will be unprotected automatically. These sheets will remain unprotected after the tests have been run, except that import sheets will be protected again.
Next, each test is performed in turn. The substitutions are made and the conditions evaluated. This stage may be slow if the workbook takes a long time to recalculate. You may cancel the tests at any time by clicking the Cancel button on the progress indicator.
Finally, the results are recorded on the X~TestResults worksheet. The total number of tests, and the numbers passed and failed, appear at the top of the sheet.
Underneath, each test is listed, together with the sheet on which it is defined and its outcome. This sheet is protected: you cannot edit it in any way. The list of sheets on sheet X~Sheets will be updated when the X~TestResults worksheet is added to the workbook.
Further details about the outcome of each test are added to its definition on the test sheet.
If you are running the tests manually the progress indicator will remain on the screen, showing a brief summary of the results. Click the OK button to dismiss it and see the full results summary.