Quelltext der Seite The data object options in the Excel data manager


The Excel Data Manager offers you a quick overview of all connected Excel objects. All status information is displayed here in a list area. The Excel data manager also contains a menu area above the list area and a page area with additional functions, which also offers additional help content. When working with firesys, Excel contents can be connected to Word in different configurations (the so-called data object options). This data-object relationship defines the structural alignment of the individual Excel objects (for example, as a linked table element or data in a text object). You can already get an overview of the configuration of the individual Excel objects in the list view using symbols.

On the sample screen, a maximum configuration of all possible variants is prepared. The individual icons are then explained. 


[[Datei:Word Inhalt Excel-Daten-Manager Daten-Objekt-Optionen.jpg|center|1000px]]


== The data object options in the menu ribbon ==


=== [[Datei:Image.Common.Manager.Open.24.png|16px|link=]] Open source ===

Opens the Excel source file, displays the worksheet and marks the range selected in the list where the object originates. 

==== Open folder ====
Opens the folder where the Excel source file is stored. 

=== [[File:Image.Link.Reconnect.16.png|16px|link=]] Reconnect ===

Changes the connection of an object (to another worksheet or file) or restores a broken connection. 

=== [[File:Image.Link.Unlink.16.png|16px|link=]] Delete link ===

Removes the link to the Excel source. Tables are no longer displayed in the Excel Data Manager and can therefore no longer be updated. 

{{
Vorlage:GoodtoKnowSmall

|Gutzuwissen = The “Delete link” option transforms data in text into normal text.

}}


=== [[File:Image.Link.ChangeSource.24.png|16px|link=]] Change source ===
Change the name or location (path) of the Excel source file. 

=== [[File:Image.Common.Manager.Title.Edit.16.png|16px|link=]] Edit title ===
Create or edit the title of the selected object to make it easier to find in the Excel data manager or by using the “Search” function. Assigned titles are transferred from toolsweb to Excel. 

=== [[File:Image.Common.Manager.Comment.Edit.16.png|16px|link=]] Edit comment ===
You can write “comments” on your Excel object to make it easier to find in the Excel Data Manager or by using the “Search” function. 


{{
Vorlage:GoodtoKnowSmall

|Gutzuwissen = You can remove a comment or a title at any time by deleting the text that was entered and clicking on “OK”.

}}


== The data object options in the list view ==

{|
! rowspan="2" style="width: 10rem"| [[Datei:Image.Link.Update.MyObject.32.png|left|link=|center|80px|]]
! style="font-weight:bold; text-align:left;"|<span style="font-size:125%">The data object options </span>
|-
| 

[[File:Image.Link.IsNoUpdate.16.png|16px|link=]] '''Lock object'''

A list object can be locked and cannot be updated as a result. 

[[File:Image.Link.IsSingleUpdate.16.png|16px|link=]] '''Single update'''

The selected list object is ignored when the “Update all” function is performed and can only be updated with the “Update selection” function. 

[[File:Image.Link.IsMyObject.16.png|16px|link=]] '''My objects'''

The selected list object is given the status "My object". Objects with this status can be updated separately by using the “My objects” function. 

[[File:Image.Link.IsRelative.24.png|16px|link=]] '''Relative paths'''

The selected list object receives a relative path, i.e. the path specification of the connected Excel workbooks refers to a storage location in relation to the current directory of the Word document.

{{
Vorlage:GoodtoKnowSmall

|Gutzuwissen =  Relative paths can be switched on or off in the firesys settings in the tab "General".

}}

|-
| 
|-
| 
|}


{{
Vorlage:GoodtoKnowSmall

|Gutzuwissen = Avoid working on your Excel documents while Excel objects are being updated.

}}


{|
! rowspan="2" style="width: 10rem"| [[Datei:Tabelle.png|left|link=|center|80px|]]
! style="font-weight:bold; text-align:left;"|<span style="font-size:125%">The table options</span>
|-
| 

[[File:Image.Link.IsTable.32.png|16px|link=]] '''Table'''

A complete table from an Excel file is located in the Word document.  

[[File:Image.Link.IsTableManuallyFormatted.24.png|16px|link=]] '''Table with manual layout'''

A complete table from an Excel file is located in the Word document and was assigned a manual layout. 
| 
|-
| 
|}


{|
! rowspan="2" style="width: 10rem"| [[Datei:Daten_Text.png|left|link=|center|80px|]]
! style="font-weight:bold; text-align:left;"|<span style="font-size:125%">The data in text options </span>
|-
| 

[[Datei:Image.Link.IsDitAbsolute.16.png|16px|link=]] '''Data in text'''

Contents from an Excel cell are displayed at the required position in the Word document. 

[[Datei:Image.Link.IsDitAbsolute.16.png|16px|link=]] '''Data in text as absolute value'''

Contents from an Excel cell are displayed as an absolute value at the required position in the Word document. This inserts the number as a pure number without sign. 

[[Datei:Daten im Text-Objekte, die bei der nächsten Aktualisierung als Absolutwert gesetzt werden.png|16px|link=]] '''Data in text objects which will be set as an absolute value during the next update'''

For an already existing data in text object, the “As absolute value” option was selected. During the next update, the element is displayed as a normal data in text object as an absolute value. 

[[Datei:Daten im Text-Objekte, die bei der nächsten Aktualisierung nicht mehr als Absolutwert gesetzt werden.png|16px|link=]] '''Data in text objects which will no longer be set as an absolute value during the next update'''

For a data in text objects, the “As absolute value” setting is removed. The next time the Excel data object is updated, the data in text object is displayed as a normal data in text object. 

[[Datei:Daten im Text-Objekte mit abweichender Einheit.png|16px|link=]] '''Data in text objects with a different unit'''

This icon indicates a data in text object for which a different unit was defined. 

[[Datei:Daten im Text-Objekte, die bei der nächsten Aktualisierung mit abweichender Einheit gesetzt werden.png|16px|link=]] '''Data in text objects which are set with a different unit during the next update'''

This icon indicates that a different unit was added for an existing data in text object. During the next update, the element becomes a normal data in text object with a different unit. 

[[Datei:Daten im Text-Objekte mit abweichender Einheit, die seit der letzten Aktualisierung bearbeitet wurden.png|16px|link=]] '''Data in text objects with a different unit which were processed since the last update'''

This icon indicates that an existing data in text object with a different unit was processed since the last update. 

[[Datei:Daten im Text-Objekte mit abweichender Einheit, die bei der nächsten Aktualisierung nicht mehr mit abweichender Ein.png|16px|link=]] '''Data in text objects with a different unit that are no longer set with a different unit during the next update'''

This icon indicates that an existing data in text object with a different unit was changed since the last save operation and the different unit was removed. During the next update, this element is displayed as a normal data in text object with a different unit. 

[[Datei:Daten im Text-Objekte als Absolutwerte mit abweichender Einheit.png|16px|link=]] '''Data in text objects as an absolute value with a different unit'''

This icon indicates that an existing data in text object with a different unit was set as an absolute value.

[[Datei:Daten im Text-Objekte, die bei der nächsten Aktualisierung als Absolutwert mit abweichender Einheit gesetzt werden.png|16px|link=]] '''Data in text objects which are set as an absolute value with a different unit during the next update'''

This icon indicates that an existing data in text object was changed in such a way that it now contains a different unit and an absolute value. This change will be applied the next time it is saved. 

[[Datei:Daten im Text-Objekte als Absolutwerte mit abweichender Einheit, die seit der letzten Aktualisierung bearbeitet wur.png|16px|link=]] '''Data in text objects as an absolute value with a different unit which were processed since the last update'''

This icon indicates that an existing data in text object with absolute values and a different unit was changed since it was last saved. 

[[Datei:Daten im Text-Objekte mit abweichender Einheit, die bei der nächsten Aktualisierung nicht mehr als Absolutwerte mit.png|16px|link=]] '''Data in text objects with a different unit which are no longer set as absolute values with a different unit during the next update'''

This icon indicates that an existing data in text object with a different unit and an absolute value was changed since it was last saved and the different unit and the “Absolute value” status was removed. During the next update, this element is displayed as a normal data in text object with a different unit. 
|-
| 
|-
| 
|}


{|
! rowspan="2" style="width: 10rem"| [[Datei:Abweichende_Einheit.png|left|link=|center|80px|]]
! style="font-weight:bold; text-align:left;" |<span style="font-size:125%">Different unit </span>
|-
| 

[[File:Operator.png|16px|link=]] '''Operator'''

Here you can select which mathematical operator you want to use for calculating the different unit. 

[[File:Faktor.jpg|16px|link=]] '''Factor'''

For each calculation type, one of the specified factors - 1,000 (thousand), 1,000,000 (one million) and 1,000,000,000 (a billion) can be selected. 

[[File:Nachkommastelle.png|16px|link=]] '''Displayed decimal places'''

You can define how many decimal places are displayed for your number. 
|-
| 
|-
| 
|}

{{
Vorlage:GoodtoKnowSmall

|Gutzuwissen = With divisions, the result is rounded up to the specified decimal place.

}}

 
== See also ==

[[Datei:Navigation_hoch.svg|link=]]  [[Overview_of_the_Excel_data_manager|An overview of the Excel data manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_interface_of_the_Excel_data_manager|The data object options in the Excel data manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Excel_data_manager_–_the_update_functions|Update Excel contents]]   <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_list_view_in_the_Excel_data_manager|The list view in the Excel data manager]]   <br>

{{MoreContent}}
[[Kategorie:English-Word Excelinhalte-Excel-Daten-Manager]]