When using Formula Check, 3 common question types come up most often: missing markers, whether every error must be fixed, and whether check history is available; this section covers 3 frequent questions and a glossary.
FAQ
Why did the green triangle marker disappear?
- Click the File menu.
- Select Spreadsheet Preferences.
- Open the Error Checking tab.
- Confirm that the background error checking option is enabled.
- Return to the worksheet and check whether the green triangle marker appears again.
Do all detected errors need to be fixed?
- Review the specific reason shown in the error prompt.
- Decide whether the issue affects your actual result, such as numbers stored as text.
- If it does not affect your work, you can leave it as is based on your needs.
- If it affects calculation results, revise the formula or reference range promptly.
Can I view the history of formula checks?
- Formula Check scans the current worksheet state in real time.
- After you edit formulas, run the check again to get the latest results.
- If you need a record of changes, save your own notes about the formulas before and after editing.
Glossary
| Term | Definition |
|---|---|
| Error Checking | A feature that scans worksheet formulas and flags possible issue types. |
| Circular Reference | A formula that directly or indirectly refers to itself, creating a closed calculation loop. |
| Checking Rule | A condition that determines which formula issues are flagged or highlighted. |