AX2273

Checking a sheet for formula errors

Using the Find Formula Errors tool, you can check a sheet for Excel formula errors such as #REF!, #VALUE, and #NAME?.

If a sheet has formula errors, then data cannot be saved to the database from that sheet. You can use this tool to check for errors before saving, and correct them. You can also use this tool when setting up reports, templates, or drivers, to make sure you have not accidentally introduced a formula error while editing the file.

Only standard Excel formula errors are found by the tool. Axiom function errors (#ERR) are not found by the tool, and do not prevent saving data to the database.

To check a sheet for Excel formula errors:

• On the Axiom Designer tab, in the Developer group, click Tools > Find Formula Errors.

The tool checks the current sheet for formula errors. If errors are found, they are displayed in the Save Data Errors task pane that opens in the Axiom Assistant area. This task pane lists the cell where the error was found (if applicable), and a brief description of the error. If the error is associated with a specific cell, then you can double click on the error to be taken directly to the applicable cell in the spreadsheet.

If no formula errors are found, a message box informs you of this.

NOTE: Only administrators have access to this feature in the Axiom Designer tab, however, any user can check for formula errors by running file diagnostics. For more information, see Using file diagnostics for troubleshooting and optimization.