Approve deviation

Use this function to approve non-relevant deviations of validations (e.g. in the area after the decimal point which is not displayed). Approved deviations are no longer listed as errors in the vali-dation sheet nor are they marked as errors in the Word tables.

In order to approve deviations, please do the following:

• Change to the validation sheet and highlight the validation with a deviation you wish to approve.
• Select “Approve deviation” in the “Validation and consistency” group on the “*Validation” tab.

In the following dialogue, you can select the following two approval types:

Datei:EN-Excel Validierung Abweichung-freigeben.jpg

Approve delta

Use this function if you would like to release a specific number range. The current deviation will then be directly recommended as delta. All values within this range automatically receive ap-proval.

Approve current values

Use this option to approve the current values as a deviation. The validation will be listed as a de-viation again, even if a value has only changed slightly. You can also add a comment and con-firm the dialogue with “OK”.

The deviation is approved and the respective information on the validation is shown as an Excel comment. This contains a date stamp, user information and the release value (Delta).

	Good to know
	Approved deviations are no longer listed as “Deviations” on the validation sheet under “Errors in validations”, they are listed as “Approved”.

See also

An overview of the validation functions
Create validations
Create multiple validations
Create auto-validations
Edit validation
Delete validation

Further contents

→ firesys website
→ Customer area
→ YouTube