Open the Calc document where the external data is to be inserted. This is the target document.
Select the cell where the upper left-hand cell of the external data is to be inserted.
Choose Insert > Link to External Data.
On the External Data dialog, type the URL of the source document or click the [...] button to open a file selection dialog. Press </nowiki>Enter to get Calc to load the list of available tables.
In the Available tables/range list, select the named ranges or tables you want to insert. You can also specify that the ranges or tables are updated every n seconds.
Click OK to save and close this dialog.
The Available tables/ranges list remains empty until you press Enter after selecting the URL of the source.
The OK button remains unavailable (greyed out) until you select one or more tables/ranges in the list. You can hold down the Control key while clicking on tables/ranges to select more than one.
No images are imported.
Selecting a table or range in a source document from the Web