Add external links to cells

In the Spreadsheet Editor, you can create an external link to a cell or a range of cells in another workbook. The external links to cells can be created between files within the current portal (in the online editor) or between local files (in the desktop editor).

Note: in the online editor, the ability to insert data via an external link must also be implemented on the integrator side (e.g., in a third-party document management system).

If data in the source workbook changes, you can update values in the destination workbook without copying them manually once again.

To add an external link,

1. open the source workbook and the destination workbook,
2. in the source workbook, copy a cell or a range of cells (Ctrl+C),
3. in the destination workbook, paste the copied data (Ctrl+V),
4. click the Paste Special button and choose the Paste link option (or use the Ctrl key to open the Paste Special menu, then press N).

The link will be added. If you click the cell which contains an external link, it looks like ='[SourceWorkbook.xlsx]Sheet1'!A1 in the formula bar.

To update the added external links,

1. switch to the Data tab,
2. click the External Links button,
3. select the necessary link in the list,

   

4. click the Update Values button or click the arrow next to it and choose whether you want to Update values (currently selected) or Update all.

The status will be changed to 'OK'.

When you open the workbook which contains external links, the warning appears:

Click Update to update all external links.

To break the added external links,

1. switch to the Data tab,
2. click the External Links button,
3. select the necessary link in the list,
4. click the Break Links button or click the arrow next to it and choose whether you want to Break links (currently selected) or Break all links.

The links will be broken, and the values will not be updated.

Alla pagina precedente