If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Linked workbooks

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-23-07, 08:07
RedNeckGeek RedNeckGeek is offline
Village Idiot
 
Join Date: Jul 2003
Location: Michigan
Posts: 1,941
Linked workbooks

I pretty sure this isn't possible, but it can't hurt to ask.

If a have a workbook that I populate from SQL Server every night with some business critical data. The file is in a location where people can link to it. I've been asked to add mucho info to it over the past few years, and I've lost track of who links to it and why. I'd like to audit the file to remove lines that aren't used. Is there any way to find the files that are linked to this one?
__________________
Inspiration Through Fermentation
Reply With Quote
  #2 (permalink)  
Old 07-25-07, 13:16
Sam Landy Sam Landy is offline
Registered User
 
Join Date: May 2004
Location: New York State
Posts: 931
In Excel Help, type the word "link" in the Index tab. You should find something usable in the result topic window.

HTH,
Sam
Reply With Quote
  #3 (permalink)  
Old 07-25-07, 13:38
RedNeckGeek RedNeckGeek is offline
Village Idiot
 
Join Date: Jul 2003
Location: Michigan
Posts: 1,941
Found this at microsoft.com

Quote:
Make links easy to track There's no automatic way to find all the cells in a workbook that contain links. ...
That applies to the linked workbook. That's why I think they didn't bother doing anything for a source workbook.
__________________
Inspiration Through Fermentation
Reply With Quote
  #4 (permalink)  
Old 07-25-07, 14:04
shades shades is offline
Registered User
 
Join Date: Oct 2003
Posts: 1,091
You might try the add-in: Findlink by Bill Manville (hosted on site by Stephen Bullen).
__________________
old, slow, and confused
but at least I'm inconsistent!

Rich
(retired Excel 2003 user, 3/28/2008)

How to ask a question on forums

Last edited by shades; 07-25-07 at 14:12.
Reply With Quote
  #5 (permalink)  
Old 08-03-07, 22:32
savbill savbill is offline
Registered User
 
Join Date: Feb 2004
Posts: 533
My first thought was to change the name of the file, then wait for the phone to ring when your users can no longer find or connect to it

You may want to try some of the other suggestions first.
__________________
~

Bill
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On