What does the software guidance warn about?
Microsoft distinguishes direct typing from values introduced by copying, filling, formulas or macros. Its desktop Excel guidance describes Circle Invalid Data as a way to find cells that fail existing validation criteria. It notes that the feature may not be available in Excel for the Web.
Returnables Agency is independent and is not affiliated with Microsoft. This is a tender-document review aid, not proof that a workbook is secure or that a compliance answer is substantiated. Follow the issued template and submission instructions.
What should the final workbook review record?
Check both the rule and the actual value. A permitted label can still be factually wrong, while a copied synonym can fall outside a mandatory list even if a person understands it.
| Check | Evidence | Open issue |
|---|---|---|
| Template | Issued file and revision | Was the correct workbook used? |
| Rule | Expected permitted values | Does the rule still exist? |
| Value | Completed response cell | Does it meet the rule? |
| Meaning | Requirement and supporting source | Is the answer true? |
| Exception | Approved correction or clarification | Who resolved it? |
| Delivery | Final saved submission copy | Did the checked value survive? |
How can pasting bypass a useful warning?
Illustrative example. A fictional electrical tender workbook permits Yes, No or Not applicable in a response column. A writer pastes Compliant from an internal register. No typing warning appears, and the team assumes the presence of a drop-down list proves the response is valid.
The reviewer checks the actual saved value against the issued rule, then verifies the underlying evidence before making any authorised correction. Replacing Compliant with Yes is not an automatic fix: the requirement may be unmet or need a qualification. Do not choose a passing label to remove a software warning.
What does a clean invalid-data check fail to prove?
It can only evaluate the criteria that actually remain in the workbook. It cannot prove that every expected rule still exists, that formulas reference the right cells, or that a permitted compliance answer has documentary support. Keep the buyer's original file and compare the relevant controls without changing protected structures.
Review the final saved delivery file through the approved process. If a tool or platform lacks the expected checking feature, document the limitation and arrange an equivalent authorised review rather than calling an unperformed check passed.
Common questions
What else should the bid team know?
Does pasting always trigger the typing warning?
No. Microsoft identifies several entry paths that can bypass those messages.
Does a permitted Yes prove compliance?
No. Check the actual requirement and supporting evidence.
Does removing validation circles correct the data?
No. Clearing a visual marker is not a correction to the underlying value.