Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

External Links

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

To access this command...

Choose Sheet - External Links.

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. Alternatively, click Browse button to select the file name from a file dialogue box that opens. Only then will the URL be requested from the network or file system.

A dialogue box for CSV data import appears when linking to external CSV file.

Available tables/ranges

Select the table or the data range that you want to insert. If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and OK button will remain inactive

Update every

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