Linking Files

[Darren Drake]

I am working with a model that was at one time linked to
another excel file. I can not locate where the link is on
teh existing spread sheet. I have used teh find function
to search for words in teh file name, but the program does
not find anything. It appears that the link is a phantom
link that no longer exists. Any help would be
appreciated...

 

[Stretch]

Have you tried "Ctrl/Ampersand"? That shows all formulas
on a worksheet.

 

[beth]

Go to Edit, Links to find the name of the source file.
Then search for that name using Find (Ctrl+F). Be sure to
select Formulas under Look In on the Find dialog box.