Ask Your Question

How to recognize an external data cell [closed]

asked 2016-11-20 12:15:06 +0100

janvlug gravatar image

updated 2020-09-13 17:09:33 +0100

Alex Kemp gravatar image

I have a Calc spreadsheet with a cell that contains external data from another Calc spreadsheet.
How can I see that this cell contains a link to external data. If I click on the cell, I just see the value of the external data. In the menu Edit|Links... I can see that there is a link to another document, but I cannot see where it is located in the referencing document.
I would expect something like an indicator that a cell is referencing external data, for example a menu option when right clicking the cell that indicates that the cell references external data. So, how can I see that a specific cell references external data?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-15 21:03:20.203616

1 Answer

Sort by » oldest newest most voted

answered 2016-11-20 12:25:40 +0100

janvlug gravatar image

Press F5 to open the Navigator window. Inside there is a 'Linked areas' section. In this section are the cells that contain linked data. Double click on it to select the cell containing the linked data.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-11-20 12:15:06 +0100

Seen: 85 times

Last updated: Nov 20 '16