How to create connection between data sources (automatic update) - PankoAliaksandr/Excel GitHub Wiki

Use case: You have 2 Excel documents: one is your main document and the second one is periodically updated by a program (in my case it is R output). The task is to update the main document automatically, if R output document has been changed.

How to do it:

1. Menu: Data
2. Data Call (daten abrufen, with DB icon, most left)
3. Choose a source (in our case it is "from data (aus datei) -> from Excel"
4. Find the required document
5. Do not forget to transform the data if required (there is a button for that)
6. You can change type, names(also the name of the whole imported data)...
7. Finish the operation
8. Go to Update button in menu:data (with refresh icon) and open the drop-down. Here you can find connection options, where you can make the update automatically (for instance, when opening)