ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Link? (https://www.excelbanter.com/excel-discussion-misc-queries/260133-link.html)

Ken

Link?
 
Excel2003 ...

When my WorkBook opens it asks to "Update Links" ... I think I can break
this Link??? ... I can see what WorkBook I am Linked to, but I do not know
what depends on this Link in this WorkBook???

In my WorkBook ... How do I see what depends on the other WorkBook?

Thanks ... Kha

Dave Peterson

Link?
 
If the links are in formulas in cells in the workbook, you can convert to
values.

If your links are in other locations, they may be more difficult to find/fix.

I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Ken wrote:

Excel2003 ...

When my WorkBook opens it asks to "Update Links" ... I think I can break
this Link??? ... I can see what WorkBook I am Linked to, but I do not know
what depends on this Link in this WorkBook???

In my WorkBook ... How do I see what depends on the other WorkBook?

Thanks ... Kha


--

Dave Peterson


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com