When using Formula Check, common questions usually involve missing indicators, how to interpret reported issues, and whether past checks are saved; this FAQ includes 3 common questions and a glossary.
FAQ
Why did the green triangle indicator disappear?
- Click File.
- Open Options.
- Go to the Error Check tab.
- Confirm that the background error checking option is enabled.
Do all reported formula issues need to be fixed?
- Review the reported cause in the prompt or warning.
- Decide whether the issue is an actual formula problem or an acceptable pattern for your worksheet.
- If no change is needed, you can ignore that issue; if the formula is incorrect, revise it.
Can I view the history of Formula Check results?
- Formula Check does not keep a history of past checks.
- If you need a record, note the affected cells and your revisions after the check.
Glossary
| Term | Definition |
|---|---|
| Error Check | A feature that scans worksheet formulas and reports possible issues. |
| Circular Reference | A formula that directly or indirectly refers back to itself, creating a loop in calculation. |
| Background Error Checking | Ongoing formula issue detection during editing, usually shown through indicators or prompts. |