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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|