Find Link

[G-Kid]

How do I know if my Workbook is being used / linked by other Wookbook?

 

[Bob Phillips]

This might help

Dim mpLinks As Variant

mpLinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(mpLinks) Then

MsgBox "we have links"
End If


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

If you're asking to find out if your workbook is "sending" values to other
workbooks, then I don't think you can know unless you go through _all_ the other
workbooks and look at the links there.

If you're asking to find out if your workbook is "receiving" values from other
workbooks, then Bob's answer will work.

Or just looking under Edit|Links. If that's disabled, then no links.

 

[G-Kid]

Thanks Bob & Dave.
I'm asking if my workbook is "sending" values to other workbooks.
I need to modify my workbook but worry it will affect other workbooks,
especially my boss' workbbok. Pls help.

 

[G-Kid]

Thanks David.
I'll hv to let them "pull" values from my workbook. They are my bosses who
use my data for analysis. I intend to modify some format but dont know which
data they're pulling. Is there no other way? Pls help.

 

[Dave Peterson]

Save it as a new name.
Delete the original version (actually, hide it in a safe spot!)
Wait until the phone starts ringing with complaints that the links don't work.

I'd send out an email to everyone who could potentially rely on this workbook.
Tell them of the updates that you have to make and that their workbooks may
(probably will!) break.

Give them a schedule of when you're making changes.

And cut it over.

Run this by your boss first to see if he or she will be angry enough to fire
you!

Thanks David.
I'll hv to let them "pull" values from my workbook. They are my bosses who
use my data for analysis. I intend to modify some format but dont know which
data they're pulling. Is there no other way? Pls help.