how find cells requiring a linked file?

[drain]

I've changed the name of a linked spreadsheet and want to find the cell that it was calling the link. How do I do this?

 

[IFRs]

You can Edit / Links

or Search for the original file name or perhaps a "\" chosing "Formulas" to look in.

 

[FrenchCAD]

in the Tools > Options > Display window, you can also check the Formula box. It will show forumulas in cells instead of their results.

Cyril Guichard
Mechanical Engineer

 

[ivymike]

you can also try going to Edit > Links

 

[ivymike]

oops, didn't see the above...

 

[drain]

Many thanks. I solved the problem by showing the formulas