Desktop

Ask something
Discussion Locked

Find embedded links in excel

0 helpful
2 replies

by drgear

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have inherited a large workbook that makes references to another workbook that no longer exists. How can I find the cell that references the other workbook so that I can update the formula without going through every cell in all of the tabs?

2 replies

by arumugam.kumaresan

hi
i too have the same doubt how to embed a link in one excel file to another excel file, which i use in PPT. Please let me know if anyone have the the answer for this.

Thanks
Arumugam.K

by sunny02310

Try doing a find (ctrl F) for ":\" (without the quotes). When the 'Find and Replace' box pop's up, click on 'Options >>'. Set 'Within' to 'Workbook' and 'Look in' to 'Formulas'. Assuming you don't have ":\" typed in your spreadsheet a lot, this will take you to any cell that containes a reference to another file. This is because the formula starts with "='C:\...". I'd recommend just searching for :\ though, just incase the drive was not C. You could also use a wildcard and do a search for "='?:\" if you are getting too many hits the other way.

This discussion is closed to new replies.