How can external data be linked to a spreadsheet?

Question

In the Get External Data - Excel Spreadsheet dialog box, in the File name box, specify the name of the Excel source file. Select Link to the data source by creating a linked table, and then click OK. The Link Spreadsheet Wizard starts and guides you through the linking process.

How do I Link external data in Excel?

To open the Existing Connections dialog box, select Data > Existing Connections. You can display all the connections available to you and Excel tables in your workbook. You can open a connection or table from the list and then use the Import Data dialog box to decide how you want to import the data.

How do you Link external data?

Using the External Data dialog1Open the Calc document where the external data is to be inserted. ... 2Select the cell where the upper left-hand cell of the external data is to be inserted.3Choose Insert > Link to External Data.4On the External Data dialog, type the URL of the source document or click the [...]Linking to external data - Apache OpenOffice Wiki

Link to external data option is available under Insert menu.

Expert · Answer