Results 1 to 4 of 4

Thread: Links (97)

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Links (97)

    We have a bunch of spreadsheets at work that have links within to other worksheets and to other spreadsheets. These spreadsheets grow as time goes on and get copied for use in other applications. Eventually the links change or disappear and when answering yes to the question "Do you want to update the links to other workbooks" and Excel cannot find the other workbook it causes questions to be asked.

    Is it possible to automatically scan a workbook to highlight the cells that are linked to worksheets outside the current file to easily identify where problems may exist?

    Thanks,

    Simon

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Links (97)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Simon

    Links are a bad thing in MS-Excel. They are good when you know hoe to use them, and can be a great pain when they get mixed up.

    Luckly there are a few tools that can help make links a good thing. If you scan the lounge for links, you may find some messages that have links to Bill Manville's add-in which does a great job, or the Microsoft one that does again a good job.

    You see when you copy a workbook to another and change its name, Excel is smart enough to keep things the way it thinks they should be. This can be a good thing and a bad thing. So try and think about ways that you can still copy the workbook and yet keep the links, mainly formulas, pointing to the right workbook.

    One way of doing this is to globally change the <font color=red> FIRST </font color=red> = in all formulas to a unique string that you would not expect to see in real life. I use the example of zzzXXXzzz and then save the workbook and then globally change that string back to an = and the formulas are the same. basically you trick Excel in thinking that these are not formulas.

    But again use the utilities mentioned, they do a better job.

    HTH

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Links (97)

    Wassim has summed up the risks of Links pretty well. Don't forget that Edit, Links, Change Source is also available to reset those strayed Links. But be sure you Change Source to the appropriate file.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Links (97)

    Here is one of the posts Wassim mentioned.
    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
  •