Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nightmare of Links

    I've got a real puzzler. One of our company's clients has a budget sheet which links at least six(!) workbooks together:

    -Four(4) fiscal quarters
    -A Previous Year summary
    -The Current Year Summary

    In addition each workbook has their own internal and external links. The person who created this monster is no longer here - go figure - and they are now saying that the links aren't updating data correctly.

    Two questions:

    1) Is there an analysis tool available to look over the workbooks and produce a map of links (like the Access DB table relationships or something similar)?

    2) Is there a way to scan an entire workbook to find errors?

    They are running Excel 2000 SR-2 (on Win98SE).

    Thanks!!!
    MyOpic

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

    Re: Nightmare of Links

    The link to Bill Manville's utility reminded me. Sorry I didn't respond to the original post.

    Check out a <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=30606&page=&v iew=&sb=&vc=1#Post30606>previous link</A>- which was to do with removing external links. But both utilities mentioned will work just as well to find the links. It only deletes them optionally (but only work on a backup copy just in case!)

    It will not verify any links. It will not map them further either. But once have the links there in one place, it will be easier to verify them.

    A problem for verifying manually is that links can come from a variety of sources- not just formulas (eg, graphs, named ranges). The utilities do a very good job at finding these. There is one problem with both of them- because of a Microsoft bug- but that's only in removing the links, not in finding them.

    For what you are trying to do, it's a one-off exercise, and you can apply the utilities to each linked spreadsheet and build the tree manually.

    Then do your best to unlink them and make it easier for you or your successor in future!
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    New Lounger
    Join Date
    May 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nightmare of Links

    Thanks so much!! That was just the trick I needed!!

    Myopic

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nightmare of Links

    You should check out a utility called FINDLINK.ZIP (by Bill Manville), to be found at:

    http://www.bmsltd.ie/mvp

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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