Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

how find cells requiring a linked file?

Status
Not open for further replies.

drain

Civil/Environmental
Mar 10, 2003
49
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?
 
Replies continue below

Recommended for you

You can Edit / Links

or Search for the original file name or perhaps a "\" chosing "Formulas" to look in.
 
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
 
Many thanks. I solved the problem by showing the formulas

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor