A Microsoft Office (Excel, Word) forum. OfficeFrustration

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   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

spreadsheet links



 
 
Thread Tools Display Modes
  #1  
Old January 13th, 2010, 08:03 PM posted to microsoft.public.excel.links
Patti
external usenet poster
 
Posts: 231
Default spreadsheet links

I have a spread sheet I want to move. but I don't know if there are
spreadsheets linking to it. Do you know how to find out?? I know about
edit/links/ source files, but I think actually what I am looking for is the
other side of that.

Clear as mud???

thanx

  #2  
Old January 13th, 2010, 08:27 PM posted to microsoft.public.excel.links
Dave Peterson
external usenet poster
 
Posts: 19,791
Default spreadsheet links

There's nothing built into excel that will help identify the other workbooks
that link to this one.

If you only were concerned with a few, you could open them and then check
(edit|links stuff).

If you were only concerned with a few folders, you could open each workbook in
those folders and then check.

But you may never be able to find all the linking workbooks--they could be on
protected servers that you can't even get to. They could be on thumbdrives that
you can't access. They can be anywhere.

When I had to do this kind of thing, I'd try to send out an email to all the
users (I knew about) and say "it's going off line and tell anyone you know who
uses this file and is not included in this message".

Then I'd rename the file and wait for the complaints to start coming in.



patti wrote:

I have a spread sheet I want to move. but I don't know if there are
spreadsheets linking to it. Do you know how to find out?? I know about
edit/links/ source files, but I think actually what I am looking for is the
other side of that.

Clear as mud???

thanx


--

Dave Peterson
  #3  
Old January 14th, 2010, 12:18 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default spreadsheet links

Patti

What Dave has said is correct.
However, if you want to check a particular drive for files that link to
your file I can send you a utility that will do it (slowly).

Just email me at Bill underscore Manville at compuserve dot com and ask
for a copy of LinkManager, reminding me of your particular requirement.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

 




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.