Results 1 to 9 of 9
  1. #1
    n2cheval
    Guest

    Excel 97 External Remote References

    Is there a way to programically search out external references to other workbooks? I've searched all cells that I thought something my be there (A1 to Z256) formula's for external links yet found none. Though going into Edit, Links, it tells me that there is still something linking to an external workbook. This problem is started by copying a worksheet from one workbook to another.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 External Remote References

    Q138619 in the MS Knowledge Base may help you.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel 97 External Remote References

    You could try searching each worksheet for xls (or xl?) which might find reference to any other workbook.

    Failing that try these previous threads that dealt with the issue :

    <center><A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=14273&page=&v iew=&sb=&vc=1#Post14273>Automatic Links to Information in Another Workbook </A>
    or <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=696&page=&view=&s b=&vc=1>Removing links</A></center>

    Andrew C

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 External Remote References

    Examine your 'copied' sheet for named ranges which have references to external sources. Also, charts, buttons, and other objects may have external links as well.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 External Remote References

    In particular, look at eiteher of the two following "remove external links" routines:
    <A target="_blank" HREF=http://www.accountingadvisors.com/exdownload.htm>Bill Manville's utility</A>

    and <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q188/4/49.ASP>Microsoft's version</A>

    They both work OK, and can help to find references where you might not expect to look (hidden named ranges for instance).

    There is a circumstance where neither works in removing the link, but you can at least find the link.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    n2cheval
    Guest

    Re: Excel 97 External Remote References

    Thanks. I found a microsoft utility from this link.

  7. #7
    n2cheval
    Guest

    Re: Excel 97 External Remote References

    I grabed the utility and will test it Monday, thanks.

  8. #8
    n2cheval
    Guest

    Re: Excel 97 External Remote References

    Yep, that was the first thing I tried, programmically examined every cell from A1 to Z256, didn't need to yet, had to try.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 External Remote References

    When you check it,
    feedback sould be welcome.

    In particular, Which utility? Ease of use? How effective?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •