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.

Sources: Microsoft: Microsoft Support: Display or hide circles around invalid data, desktop Excel guidance, checked 21 October 2026

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.

What should the final workbook review record?
CheckEvidenceOpen issue
TemplateIssued file and revisionWas the correct workbook used?
RuleExpected permitted valuesDoes the rule still exist?
ValueCompleted response cellDoes it meet the rule?
MeaningRequirement and supporting sourceIs the answer true?
ExceptionApproved correction or clarificationWho resolved it?
DeliveryFinal saved submission copyDid 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.

Primary sources

  1. Microsoft Support: Display or hide circles around invalid data, desktop Excel guidance, checked 21 October 2026Microsoft