Approve deviation: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 31: | Zeile 31: | ||
== See also == | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[The_validation_basic_functions|An overview of the validation functions]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Create_validations|Create validations]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[Create_validations|Create validations]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Create_multiple_validations|Create multiple validations]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[Create_multiple_validations|Create multiple validations]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Auto-validations_in_firesys| | [[Datei:Navigation_rechts.svg|link=]] [[Auto-validations_in_firesys|Create auto-validations]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Edit_validations|Edit | [[Datei:Navigation_rechts.svg|link=]] [[Edit_validations|Edit validation]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Delete_validations|Delete validation]] <br> | ||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie:English-Excel Dokument-Validierungen-Contentebene]] | [[Kategorie:English-Excel Dokument-Validierungen-Contentebene]] |
Version vom 6. Januar 2020, 14:25 Uhr
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:
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