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. (missing or bad snippet)

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.