How to find if workbook is being linked to

Julie · External Since: Apr 28, 2006 Posts: 92

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 · External Since: Apr 03, 2004 Posts: 113

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" <Julie DeleteThis @discussions.microsoft.com> wrote in message
news:42EFCC61-6C98-4BBA-87D0-4B6C0134F12B@microsoft.com...
>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.