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

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)



"G-Kid" wrote in message
...
How do I know if my Workbook is being used / linked by other Wookbook?

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 wrote:

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

--

Dave Peterson

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.

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson

Your workbook can't "send" values to other workbooks. The other workbooks
might be "pulling" values from your workbook, and (as Dave said) you won't
know that without checking all the other workbooks.

You can, of course, prevent the other existing workbooks picking up values
from your updated workbook by saving your updates with a new name or in a
new location.
--
David Biddulph

"G-Kid" wrote in message
...
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.

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson

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.

"David Biddulph" wrote:

Your workbook can't "send" values to other workbooks. The other workbooks
might be "pulling" values from your workbook, and (as Dave said) you won't
know that without checking all the other workbooks.

You can, of course, prevent the other existing workbooks picking up values
from your updated workbook by saving your updates with a new name or in a
new location.
--
David Biddulph

"G-Kid" wrote in message
...
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.

"Dave Peterson" wrote:

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 wrote:

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

--

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!


G-Kid wrote:

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.

"David Biddulph" wrote:

Your workbook can't "send" values to other workbooks. The other workbooks
might be "pulling" values from your workbook, and (as Dave said) you won't
know that without checking all the other workbooks.

You can, of course, prevent the other existing workbooks picking up values
from your updated workbook by saving your updates with a new name or in a
new location.
--
David Biddulph

"G-Kid" wrote in message
...
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.

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson





--

Dave Peterson