We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc: how to list file links?

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

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

3 Answers

Sort by » oldest newest most voted

answered 2020-01-25 16:05:05 +0200

Lupp gravatar image

updated 2020-01-25 16:08:09 +0200

The SpreadsheetDocumnt model has:
.AreaLinks (Linked areas in any single Spreadsheet)
.SheetLinks (If sheets are inserted 'From File'
.DDELinks (about which I don#t know something useful.)
.ExternalDocLinks (For tables from html sources mainly - I think)
All these links you can easily list with the help of user code.

And in addition there may be formulas referencing into external (spreadsheet-) files. They always contain (at least a sub-) expression starting with file:// For this footprint you can search with Find&Replace,
Search in: = Formulas and All sheets enabled.

For the same "footprint" you can search by user code in .FormulaArray arrays.

(Please explain if your question was based on a different intention.)

edit flag offensive delete link more

answered 2020-01-25 13:31:25 +0200

mrjjacobs gravatar image

updated 2020-01-25 13:32:07 +0200

bUserLikesAnswer = YES

iAnswerHelpful = 5

iUpVote = 1

Err.Description = "User too green to upvote. (1/5)"

bCanCloseTopic = YES

MsgBox "Thank you, m.a.riosv!",,"You have fanmail!"

edit flag offensive delete link more

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

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


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

Seen: 359 times

Last updated: Jan 25 '20