Insert values in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 50: Zeile 50:


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Synchronise and detach]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Synchronise and detach]]-->
The constant integrity of your data is a fundamental element of firesys. It should be possible to update even cross-file document structures through their connection to the firesys MeetingPoint just by pressing a button. <small>'''[[Synchronise and detach|more]]'''</small>
All master values currently linked in the workbook are matched and synchronized with the values stored in the MeetingPoint. The connection of master values to the MeetingPoint can be removed using the "Detach" function. <small>'''[[Synchronise and detach|more]]'''</small>
-----
-----



Version vom 9. April 2021, 08:46 Uhr

<imagemap>Image:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|1200px|center

desc none </imagemap>

Excel Funktionen 64.png
Insert values in Excel

With version 20.1., firesys is offering you a way of inserting numerical values from the MeetingPoint into your Excel document. You can use these numbers as the basis of additional operations.

Excel Funktionen 64.png

A transmitter value contains a numerical value which is found at a different location in the workbook, or in a different Excel workbook (transmitter values cannot be created on workbooks that are created by firesys). more


A manual value is a data record in the firesys MeetingPoint that contains a numerical value and a name and can be created directly in the master value manager. more


An account value is a master value in firesys that can be written to the MeetingPoint via the account folder or via the Data import and is assigned to a unique key date. more



An account calculation and an account aggregate are composed of the mathematical addition/subtraction of several account values or account calculations. more


All master values currently linked in the workbook are matched and synchronized with the values stored in the MeetingPoint. The connection of master values to the MeetingPoint can be removed using the "Detach" function. more


See also

Navigation hoch.svg Maintain Excel contents
Navigation rechts.svg Data import
Navigation rechts.svg The functions of the master value manager
Navigation rechts.svg The validation basic functions
Navigation rechts.svg An overview of the rolling forward function
Navigation rechts.svg Automated worksheet

Further contents

firesys website
Customer area
YouTube