Practical guides · Practical guide

Commissioning Excel validation: defining the workbook, intended use and evidence

You need a provider to validate an Excel workbook that calculates a quality-relevant value. For a meaningful proposal, explain whether you use it for calculation, as a record or for data transfer. Agree the requirements, suitable tests and deliverables against a specific version, including what your team needs for continued use.

Table of contents

At a glance

What needs to be clarified before commissioning Excel validation?

Commission validation for a specific Excel workbook and use. Describe inputs, calculations and decisions, then identify the version, storage location, macros, data connections and roles. Agree requirements, independently established expected values, test cases and handling of findings with the provider. Plan for later changes. The suitability conclusion applies to this defined use and its controls, not to all of Microsoft Excel or every similar workbook.

  • File, process, and usage conditions collectively constitute the inspection objective.
  • A leaf shield alone provides neither valid calculations nor controlled usage.
  • Test results must be justified independently of the specific formula being evaluated.
  • After handover, the documentation shall include a clear and traceable maintenance pathway.

Which work folder is to be reviewed?

Name the controlled output file and its version. Describe who uses it, where it is stored, and what happens to completed copies. A locally stored inspection protocol has different work processes compared to a central template with multiple distributed copies. These differences must be visible in the instruction.

In addition, define the boundaries of the process under consideration. Which data are recorded in the file, what processing takes place there, and which decisions are based on the results? Supplement linked records and subsequent transfers. The presentation in the worksheet alone does not always clearly indicate which information must be retained for future audit purposes.

Sources: [1] [2]

What the formula calculates and what it is intended to achieve technically

A service provider can technically verify a formula. To assess whether it accurately represents the intended purpose, they also require appropriate process or methodological expertise. Therefore, the underlying logic of the formula should be described independently of the Excel formula: including units, limits, rounding rules, and the intended handling of missing or invalid inputs.

If a limit value appears as text, an empty cell, or a unit in a different column, describe the intended handling. Such cases are not captured by a validation check relying on a single nominal value. Avoid general statements such as "all formulas have been tested" when it remains unclear which specific professional judgments and error scenarios have actually been evaluated.

Sources: [1] [3]

Further reading:

Clarify the scope of an external inspection

Agree whether the provider will assess the file, help develop requirements, write tests or run them. Identify who supplies expected values and who corrects formula or macro errors. If the file changes during testing, identify the new version and assess the impact.

The matrix links the work folder with the required results. Adjust the grouping based on risk and usage to ensure that requirements, review, actual results, and the associated file are clearly and logically connected.

Clarify the scope of an external inspection
AreaRequired source informationExpected result
Technical Application Purpose, decision, input and output data Limited requirements
Formulaa and Macro Logic Current status and professional calculation guidelines Rational evaluation of relevant functions
Inputs Permissible values, units, and error conditions Appropriate normal, boundary, and negative cases
Records Template, completed file, report, and handovers Clear arrangements for evidence and retention
Changes Responsible Parties, Version Control, and Distribution Controlled care of the validated template
Closure Results and Open Issues Assessed suitability for intended use

Sources: [1]

Where do the correct reference values come from?

When the same formula generates both the result and the expected value, a common error may remain undetected. Therefore, establish an appropriate independent derivation. This could, for example, be a logically traceable manual calculation, a professionally justified reference, or another appropriately assessed method.

Independence does not automatically imply the use of a second computer program. In such cases, the same incorrect rules may still be adopted. Explain why the selected reference supports the intended conclusion. Additional subject-matter expertise may be required for more complex calculations. Responsibility for this should be assigned in the mandate, rather than remaining open during test execution.

Sources: [1] [3]

Further reading:

Prepare specific boundary and error scenarios

Consider, in addition to appropriate inputs, values at a relevant boundary, missing entries, and unexpected data types. For a result determination, it may be important whether rounding occurs before or after boundary value evaluation. The expected sequence must be professionally defined.

For critical, manually entered data, Annex 11, Section 6, requires an additional accuracy check by a second person or through validated electronic means. A simple area review, for example, would not detect a swapped but still acceptable measurement value. Therefore, specify which entries are considered critical and how their accuracy is independently verified.

Also, plan transfer and operation cases that occur in your actual work. This may include inserting values, additional lines, modified cell references or updated source files. Whether a particular case is relevant is the result of usage. The selection has to be justified; there is no universal test case number for each Excel file here.

  • Handle blank, invalid and implausible inputs appropriately.
  • Verify unitings and conversions are understandable.
  • Define limits and rounding sequence in advance.
  • Consider relevant cell associations and accepted data.
  • Compare the printout or export with the information the process needs it to show.

Sources: [1]

Further reading:

Think about protection, versioning, and retention.

Microsoft explicitly states that worksheet protection does not provide a security function. It prevents modifications to locked cells but neither replaces access control nor ensures controlled audit logging. Distinguish between file protection, workbook protection, and worksheet protection, and identify their actual purposes.

Annex 11 No. 12.4 specifies for data and document management the recording of the individual responsible, date, and time at the time of data entry, modification, confirmation, and deletion. No. 9 addresses a risk-based evaluation of audit trails for GMP-relevant changes and deletions, including the rationale for such changes. Please inquire with the vendor on how the selected solution implements this for your records. Verify, based on the specific system design, whether the required history is actually available. A file version history alone does not fully address the need to trace a single relevant change. If required functions are missing, the solution or process must be adjusted accordingly.

Therefore, a clear and understandable separation between controlled templates and edited records must be established. Who is authorized to release a new template? How can an employee identify the current valid version? How are required results and their context obtained? Technical safeguards and long-term retention of a traceable record serve distinct purposes.

Sources: [1] [2] [4]

Further reading:

Assess the supplier for a specific testing task

In the selection interview, specify a edited sample file and a business rule. Let the provider explain how to derive independent target values, select relevant borderline and error cases and keep track of the checked situation. An appropriate proposal also specifies who decides professionally and how the template is then maintained and distributed.

The matrix is an independent selection tool. For agreement, supplier assessment, and personnel qualification, the requirements outlined in Annex 11 No. 3 and Chapter 2 No. 2.23 of the Tender Guidance Document apply. A commitment such as "We validate Excel" without a defined use case and documentation pathway does not constitute sufficient validation evidence.

Assess the supplier for a specific testing task
Selection questionUsable answerClarify before commissioning
How do you verify the calculation? Independent derivation and professional acceptance criteria Who provides or evaluates the reference?
What occurs with incorrect entries? Specific critical manual entries and corresponding controls What additional accuracy verification is required?
What coding proficiency do you bring? VBA testing intended to be traceable or cleanly segregated Who is responsible for managing macros and their modifications?
How is recordkeeping traceable? User, time, and change history of the specific solution Which functions are still missing?
What remains after transfer? Controlled template, documentation, and stated care pathway Who is responsible for distribution and changes?

Sources: [1] [5]

Further reading:

Continue using the checked file in everyday life

Review the results with the subsequent responsible party during a representative exercise. Document the verified status, intended use conditions, and any remaining restrictions. Open issues require a clear and justified evaluation. Conclusion shall not be based solely on the existence of a test protocol stored in a folder.

Additionally, agree upon the actions to be taken in cases of modified formulas, new inputs, a different operational environment, or additional data connections. A change does not automatically render prior validation evidence obsolete. However, its impact must be assessed in relation to the intended use and existing coverage. This very attribute of maintainability should be part of the engagement.

Sources: [1]

Project experience and collaboration

Define the Excel workbook and the decision it supports

Bring one workbook and the business rule behind its calculation. Together, we trace the inputs through to the decision that relies on the result. This helps us agree the reference values, tests and controls for the assignment. A single template may need a limited assessment. If you have many variants, first establish which files actually belong to the same family.

Frequent Questions Regarding the Engagement of an Excel Validation Specialist

Is the service provider Excel or our workbook validated?

The specific subject of evaluation is the defined scope of use, including the specific file, environment, and required controls. A general statement that Excel is validated does not adequately describe your calculations or documentation. Therefore, explicitly define version, file status, intended use, and relevant data pathways in the instruction.

Sources: [1]

Which sample trial assists in the selection of a vendor?

A revised template file with a specific, actionable decision rule is more helpful than a general presentation. Explain the derivation of a target value and a meaningful error scenario. Then assess how the supplier handles the actual recording, its history, and subsequent maintenance. Confidential customer data is not required.

Is leaf protection sufficient as a control?

No, as the sole control for a GMP-critical process, it is insufficient. Microsoft explicitly classifies worksheet protection as not a security function. Accuracy, authorized access, traceable modifications, and retention require appropriate additional measures within the specific solution. Let the effectiveness of such measures be demonstrated in the intended application environment.

Sources: [1] [4]

Who is responsible for providing the expected computational results?

The responsible party must be able to justify the underlying rules and acceptance criteria. An external expert may contribute to developing appropriate references and test data. Explicitly define the scope of responsibility. Expected values must not be unverifiedly derived from the same logic being assessed for correctness.

Which hand inputs require an additional test?

Assess which manually entered data are critical for the relevant quality decision. According to Annex 11, Section 6, an additional accuracy check by a second person or by validated electronic means is required. A simple plausibility check is not sufficient in all cases. Maintain a record of the selection and actual control performed on behalf of the decision.

Sources: [1]

What should remain within the team after completion?

Your team requires a controlled template, traceable requirements and verification evidence, along with a clear rule for usage and modifications. Additionally, defined responsibilities and the necessary records must be established. The exact document structure may vary. What is essential is that the workflow remains consistent with and is clearly explained in the intended mode of operation.

Sources and review date

Primary source date: 17 October 2026. The article addresses GMP-relevant Excel usage in human medicinal product manufacturing. It describes a specific approach to order clarification and does not cover general product release of Microsoft Excel. Analytical method validation, specific VBA code review, and company-specific retention periods must be considered separately.

  1. European Commission: EU GMP Annex 11, Computerised Systems, January 2011 revisionHuman medicinal products – GMP; in particular, §§1–4, 7, 10–13, 16–17; specific application for each section.
  2. European Commission: EU GMP Chapter 4, Documentation, January 2011 revisionControlled documentation and records; official EudraLex entry with original chapter.
  3. ICH Q9(R1): Quality Risk Management, official text from the European CommissionRisk-driven decisions, appropriate formalities, and handling of subjectivity; own matrices are implementation proposals.
  4. Microsoft Support: Protection and security in ExcelSheet, folder, and file protection distinctions; no complete GxP documentation.
  5. European Commission: EU GMP Chapter 2, Personnel, effective from 16.02.2014Personal, role-specific training and assessment of practical effectiveness; official EudraLex entry with original chapter.

Sources checked: .

Daniel Herrmann, Daniel Herrmann Consulting

Daniel Herrmann Consulting

Describe their Excel audit object

Maintain a controlled example file, the intended use, and the technical calculation rules. This enables clarification of which questions are already addressed and where a detailed analysis is required.

  • Computer system validation →

    Bring your GxP systems into validated operation, from laboratory software, MES and eQMS to ERP. We define the scope, plan risk-based tests using GAMP 5 and hand the evidence to QA for release.

Send a project enquiry Customer testimonials →