Calc: how to list file links?

[ajlittoz]

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 ?

[mariosv]

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.

[mrjjacobs]

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!”

[Lupp]

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.)