Update Links

[tc]

hi. each time i open my workbook, Excel informs me that the sheet
contains links to other sources, would i like to update. is there a
way to know as to which cells are linked to external sources?

 

[Jayarama Vytla]

Troy,

When you have formula links in an Excel Workbook (destination) to another
Excel Workbook (source) you will be asked if you wish to update links in the
Workbook (destination) each time you open it. This can be painful when you
always want, or don't want, links updated.

It isn't hard to find links without a macro. Simply use Edit|Links and
you'll usually be able to see the first source file's path and filename
listed against 'source file:'. If your workbook is linked to more than one
file, selecting each in turn will reveal it full details. So, now all you
need to do is a 'find' for those.


Best Regards,
Jay

 

[Dave Peterson]

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