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  

Determine what sheets are linked to sheet A



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2008, 08:59 PM posted to microsoft.public.excel.links
David
external usenet poster
 
Posts: 1,494
Default Determine what sheets are linked to sheet A

Hi,

I want to move a spreadsheet, call it Sheet A.

Is there a way to determine what other sheets link to Sheet A?

Thanks,
--
David
  #2  
Old April 23rd, 2008, 09:59 PM posted to microsoft.public.excel.links
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Determine what sheets are linked to sheet A

If you're lucky and haven't used the exclamation point except in formulas that
link to other sheets, you could search for that.

If you're not lucky, you could move the sheet and then search for .xls or []'s.

And after you've moved the sheet (so the external links are created), you could
use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm



David wrote:

Hi,

I want to move a spreadsheet, call it Sheet A.

Is there a way to determine what other sheets link to Sheet A?

Thanks,
--
David


--

Dave Peterson
  #3  
Old April 24th, 2008, 03:19 AM posted to microsoft.public.excel.links
David
external usenet poster
 
Posts: 1,494
Default Determine what sheets are linked to sheet A

Hi Dave,

So I am sure you understand the issue... Sheet A has data in it. I wonder
if there are other unknown Sheets which refer to/link to cells in Sheet A.

If I understand your response, it sounds like you suggest I look in Sheet A
for where links might exist, which is the opposite of what I am looking for.

Thanks.
--
David


"Dave Peterson" wrote:

If you're lucky and haven't used the exclamation point except in formulas that
link to other sheets, you could search for that.

If you're not lucky, you could move the sheet and then search for .xls or []'s.

And after you've moved the sheet (so the external links are created), you could
use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm



David wrote:

Hi,

I want to move a spreadsheet, call it Sheet A.

Is there a way to determine what other sheets link to Sheet A?

Thanks,
--
David


--

Dave Peterson

  #4  
Old April 24th, 2008, 06:03 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Determine what sheets are linked to sheet A

I think by Sheet A you are meaning a workbook, not a worksheet within a
workbook as Dave took you to mean.

I have an alternative free utility which you can use to look in all xls
files in a directory structure, looking for links to a particular
workbook. If you would like to try it, email me at Bill_Manville at
compuserve dot com

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 11:16 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.