#1   Report Post  
Old January 13th 10, 07:03 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 45
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   Report Post  
Old January 13th 10, 07:27 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
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   Report Post  
Old January 13th 10, 11:18 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get rid of old links in a spreadsheet? JeremyInNC Setting up and Configuration of Excel 3 September 12th 06 10:30 PM
Spreadsheet links Karen Excel Discussion (Misc queries) 1 September 11th 06 02:58 PM
Spreadsheet Links have me stumped! nander Excel Discussion (Misc queries) 2 April 18th 06 03:56 PM
Spreadsheet links Marshall Scmidt Excel Discussion (Misc queries) 2 October 28th 05 04:30 PM
Links to tabs within a spreadsheet Steve R. Links and Linking in Excel 1 May 20th 05 12:32 AM


All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017