Excel data manager – the update functions: Unterschied zwischen den Versionen

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


=== [[File:Image.Link.Update.Status.32.png|16px|link=]] Status update ===
=== [[File:Image.Link.Update.Status.24.png|16px|link=]] Status update ===


Checks whether the selected Excel objects (and objects linked to them) are up to date and updates the information in the list. The Excel objects are not updated.  
Checks whether the selected Excel objects (and objects linked to them) are up to date and updates the information in the list. The Excel objects are not updated.  

Version vom 19. April 2021, 09:45 Uhr

To ensure that linked Excel objects in your Word document are always up to date, you can use the update functions to update existing Excel objects quickly. You can choose whether you want to update only one object, all objects that are currently selected, or all objects that are linked in the Excel data manager.


EN Word Inhalt Excel-Daten-Manager-Aktualisierungsfunktionen.jpg


The update function

Image.Link.Update.Selection.16.png Update selection

Checks and updates the selected object or objects in the list. The system checks the linked Excel objects for changes in content and structure and, if changes have occurred since the last update, updates the data in your Word document.

RxbtnUpdateMyObjects 16.png Update my objects

Updates all Excel objects labelled as “my objects”.

Datei:RxbtnUpdateAllObjects 16.png Update all

Checks and updates all Excel objects contained in your document and creates an update report, which also indicates if any problems occurred during the update (for more information, see Update/troubleshooting).


Glühbirne neu.png
Good to know

Avoid working on your Excel documents while Excel data is being updated.


Image.Link.Update.Status.24.png Status update

Checks whether the selected Excel objects (and objects linked to them) are up to date and updates the information in the list. The Excel objects are not updated.

Application example


A detailed explanation of the individual steps

This is how you update linked Excel objects with firesys, in three different ways:

  • Option 1: By using the “Update” function in the menu ribbon (shown in this video)

    1. Use the mouse pointer to select a linked Excel object that you want to update.

    2. In the “*Content” menu ribbon, in the “Excel data manager” group, click on the “Update” button.
      → A progress dialog appears.
      Note:The “Update all Excel objects” function is also available on the split button.
      →The Excel object was updated.

  • Option 2: By using the context-sensitive menu in firesys

    1. Use the mouse pointer to select a linked Excel object that you want to update.

    2. Right-click in the object’s area.
      →The context-sensitive menu appears.

    3. Here you can select the “Update” function.
      → A progress dialog then appears.
      → The Excel object was updated.

  • Option 3: By using the menu ribbon in the Excel data manager

    1. Use the mouse pointer to select a linked Excel object that you want to update.

    2. In the “*Content” menu ribbon, in the “Excel data manager” group, click on the “Excel data manager” button.
      →This opens the Excel data manager and the “Update” ribbon contains the update functions.

    3. Here you can choose whether you want to update all or just the selected Excel objects.
      →A progress dialog then appears.
      → The Excel object(s) are updated.

See also

Navigation hoch.svg An overview of the Excel data manager
Navigation rechts.svg The Excel data manager interface
Navigation rechts.svg Insert Excel contents
Navigation rechts.svg The firesys settings in Word for data from Excel

Further contents

firesys website
Customer area
YouTube