Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you locate External References in an Excel Workbook
How do you locate the cells which have an external reference? I have tried
using the links function, but this only shows the files that are referenced, not the cells that relate to them. Thanks, |
#2
|
|||
|
|||
If you're having trouble finding those links, you can use Bill Manville's
FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Iain wrote: How do you locate the cells which have an external reference? I have tried using the links function, but this only shows the files that are referenced, not the cells that relate to them. Thanks, -- Dave Peterson |
#3
|
|||
|
|||
You can use the excellent utility FINDLINK.XLA, which is freely available
for download from Bill Manville on the following site:- http://www.bmsltd.ie/mvp/ This will allow you to find all the links and will also allow you to break them if you wish. One culprit for a link that cannot be found is that you may well have a named range that is linked to another workbook. If you go into Insert / Name / Define and then click on each of the names in turn and look at the reference at the bottom of the dialog box - you may well come across one that refers to another workbook. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Iain" wrote in message ... How do you locate the cells which have an external reference? I have tried using the links function, but this only shows the files that are referenced, not the cells that relate to them. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |