G
G-Kid
How do I know if my Workbook is being used / linked by other Wookbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
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)
D
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.
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
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.
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.
D
David Biddulph
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.
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.
G
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.
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.
D
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!
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 said: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.