Link to External Data /text/scalc/01/04090000.xhp Sun Microsystems, Inc. UFI: changed name of menu (sc-features Calc: New menu entry "Sheet from File" in Insert menu) dedr: reviewed
Locate the file containing the data you want to insert. Link to External Data 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.
To import data from a *.csv or *.txt file, choose File - Open and then select the Files of type "Text CSV".
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.only after Enter the URL will be requested from the net. 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.