# Calc: how to list file links?

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 close merge delete

Sort by » oldest newest most voted

more

iUpVote = 1

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

bCanCloseTopic = YES

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

more

.SheetLinks (If sheets are inserted 'From File'
.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.