Results 1 to 13 of 13

Thread: Tracing Links

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Tracing Links

    I would like to know if Excel has a feature that will highlight/point out where a link is embedded in a spreadsheet? If not, any other ideas?

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

    Re: Tracing Links

    If you don't have too big an area to examine, you could try Tools / Options / View and check on the Formulas box. That would allow you to do a quick visual examination of all formula cells to look for external references. Other than that, there are a couple of VBA tools around that will locate / list links. I don't have the references handy at the moment.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tracing Links

    Thanks, GeneO, Iwas aware of the latter methon; Iwas just looking for a "quick fix"!

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

    Re: Tracing Links

    I use the tedious process of searching for the link name. I'm looking for a better way.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Tracing Links

    Also, you could try using Go To (F5) and pressing the Special button, and look for Formulas. If you were doing a lot of this, I'd customize the toolbar.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Tracing Links

    How do you use Goto, Special for links?
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracing Links

    Quick and dirty: Edit|Find "!" or, if you are sure links do not refer to named cells, "!$", then keep hitting F3.

    If used regularly/need to document it: IMO only with a VBA sub.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tracing Links

    "VBA sub" (a novice here)?

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

    Re: Tracing Links

    Augh! I do extensive and sometimes complex search-&-replaces, but I never thought to search for "!" alone. Thanks!

    (Bangs head on desk, begins muttering passive-aggressively.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Tracing Links

    Well a link is a formula. GoTo Special, lets you look specifically for formuals. You'll also find regular formulas as well - can't get away from that.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  11. #11
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracing Links

    <P ID="edit"><FONT SIZE=-1>Edited by gwhitfield on 01/01/11 08:30.</FONT></P>It's an Excel "macro". I differentiate between VBA functions and subs.

  12. #12
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tracing Links

    <P ID="edit"><FONT SIZE=-1>Edited by gwhitfield on 01/01/11 08:38.</FONT></P>Sorry-I am truly a novice at this and don't know what you mean by "VBA".

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

    Re: Tracing Links

    Hi,

    A "VBA macro" is a routine which can be run behind Excel (or Word or other applications) which can do all sorts of usefule things for you. It may be to the spreadsheet (or Word document); it may just pop up windows and do nice things for you without doing anything to Excel.

    It's a programming language behid Excel, with the programming language based on Visual Basic (VB). As applied to an application like Excel, it becomes Visual Basic for applications (VBA).

    What does all that %$# mean?

    OK, in its most simple form, you can automate a repetitive task- that's what the earlier postings were saying. So you can click on Tools, Macros, record macros- and then any actions you perform are recorded in "VBA" code. When you've finished your sequence of actions, click on Tools, Macros, Stop reording; if you then press on Tools, Macros, Macros, then select the macro you have just recorded, it will repeat the actions.

    That's it's most simple form.

    You may find that you have requirements to do much more than what you can achieve just recording and replaying. You can tweak what you've recorded; you can add functionaltity; you can build whole applications using what is actually a very powerful language.

    But you probably don't need to worry about those bits. Just the "Record" and "Play" functionality should help you in what you want to do.

    My apologies for changing the previous 2 posts- there was obviously a misunderstanding there.
    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
  •