Data --> Links Error

[dramnath1981]

Hi,

I have a file with 10 sheets with formulas connecting to different files.

Of which, I believe the linkage is lost in 2 of the files, as they are not saved.

Can anyone please guide me on how to identify the sheet and the particular cell which has some reference to the 2 unsaved files?

The status is reading as "Error: Source not found" when you go to Data Menu --> Edit Links.

Please help.

Regards, Ramnath

 

[Chihiro]

External reference should contain "[" in formula.

Therefore you can search using Ctrl+F

 

[dramnath1981]

Thanks. Got it.