Ask Your Question
1

Calc: how to list file links?

asked 2016-05-26 08:08:24 +0100

ajlittoz gravatar image

I received a rather large Excel spreadsheet. When I open it, I get "Do you want to update links to other files?" dialog. Since this spreadsheet is supposed to be independent, I click "No" and I don't see any adverse effects (apparently). I sampled a few cells and didn't see foreign references, but it is not possible without significant manual effort and time to exhaustively test every cell. However, I'd like to discover the source of the question in order to discuss with the sheet author (it may even be the remnant of some other sheet if it was reused for this case).

  1. How to list all referenced files in a spreadsheet ?
  2. Given a foreign file, how can I get at least one referencing cell ?
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-11-04 14:45:57 +0100

m.a.riosv gravatar image

You can see linked files in Menu/Edit/Links to external files. Then you can search for them with Menu/Edit/Find or Menu/Edit/Find & Replace, the last it's more customizable.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-05-26 08:08:24 +0100

Seen: 143 times

Last updated: Nov 04 '18