Approve deviation: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 9: | Zeile 9: | ||
[[Datei:EN- | [[Datei:EN-Excel Validierung Abweichung-freigeben.jpg|center]] | ||
Version vom 6. Januar 2020, 11:52 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
Validations in Excel
Create validations
Create multiple validations
Auto-validations in firesys
Edit validations
Delete validations
Weitere Inhalte
→ Webseite
→ Kundenbereich
→ YouTube