Link to External Data

From LibreOffice Help
Jump to: navigation, search

Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range.

Choose Sheet - Link to External data

Inserting External Data in Table (WebQuery)

URL of external data source.

Enter the URL or the file name that contains the data that you want to insert, and then press Enter.

Available tables/ranges

Select the table or the data range that you want to insert.

Update every

Enter the number of seconds to wait before the external data are reloaded into the current document.