[Julie]

I need to make some changes to a Workbook A but don't know how many other
workbooks link to it. I'd like to open the other workbooks before I make the
changes Workbook A so the links don't get messed up.

[Bob Flanagan]

Julie, you don't have many choices. You will need to open all workbooks
that can possible have a link to the workbook and see if they have a link to
it by selecting Edit, Links after opening a workbook. The choices are to do
manually or with a macro or add-in. If a lot of files, the second approach
is obviously easier. I know one of the products at my site can do it, the
Link Finder, http://www.add-ins.com/linkfind.htm.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Julie" wrote in message
...
I need to make some changes to a Workbook A but don't know how many other
workbooks link to it. I'd like to open the other workbooks before I make
the
changes Workbook A so the links don't get messed up.