Additional functions in the master value manager: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 51: | Zeile 51: | ||
Each individual master value is displayed as a list entry and contains information about the name of the Excel worksheet in which the master value occurs (in this example, “Overview P&L” and subsequently the position of the individual cells (such as cells “E21” or “E22”) | Each individual master value is displayed as a list entry and contains information about the name of the Excel worksheet in which the master value occurs (in this example, “Overview P&L” and subsequently the position of the individual cells (such as cells “E21” or “E22”) | ||
[[Datei:EN-Excel_Werte-einfügen_ÜbersichtVerbundeneZentralwerte.jpg|center|800px]] | |||
Version vom 3. August 2020, 12:24 Uhr
<imagemap>Image:EN_Excel_Menüband_Inhalt_Zentralwerte.jpg|1200px|center rect 2 85 204 193 The_basic_functions_of_firesys rect 211 82 515 192 The_account_workbook rect 522 82 612 192 The_functions_of_the_master_value_manager rect 614 81 698 191 Synchronise_and_detach rect 884 82 1041 184 The_validation_basic_functions rect 702 114 879 136 Synchronise_and_detach rect 702 140 880 168 Insert_transmitter_values rect 705 81 878 110 Insert_values_in_Excel rect 1046 83 1181 190 An_overview_of_the_rolling_forward_function desc none </imagemap>
Additional functions in the master value manager
Master value manager
→ An overview of the functions of the master value manager
Open the master value manager and manage the values which were prepared in the MeetingPoint.
Linked workbooks
Lists all linked Excel workbooks which also validate with master values and/or make master values available for cross-file validations for the MeetingPoint. Here you can open the respective files or open them as write-protected and use the search function to quickly find the Excel workbook you are looking for.
If one or more Excel workbooks are no longer available, or if they have been renamed or moved, an information icon is displayed.
You can now use the “Remove from list” function to remove the relevant workbooks from the list.
 |
Good to know
|
|---|---|
If links to Excel workbooks with cross-file validations have got lost, the original path of the file is always displayed in the list area. |
Datei:RxbtnCellMultiCompareShowInXlsUsedCells 16.png Linked master values
Lists all master values that are used in your workbook. The individual master values are shown categorised by their respective master value types. Use the “Expand all” or “Collapse all” functions to navigate in the list area more quickly or to obtain information about the individual entries.
Each individual master value is displayed as a list entry and contains information about the name of the Excel worksheet in which the master value occurs (in this example, “Overview P&L” and subsequently the position of the individual cells (such as cells “E21” or “E22”)
Create archive workbook
Here you can create a workbook out of the MeetingPoint. The required account group can be listed with all accounts and values for a selected key date. Optionally, you can specify whether the information should be automatically saved in the MeetingPoint.
Write back archive workbook
Writes this archive workbook back to the MeetingPoint. This restores all accounts and values for a key date.
The “Write back” function, which writes back the archive workbook to the MeetingPoint and the “Status update” function are available for checking whether the changes made can be transferred.
Remove toolsvalidation components
Removes all components that are required for toolsvalidation from the current workbook.
See also
An overview of all functions of master values
The master value manager in firesys
Working with master values in firesys
Working with transmitter values in firesys