Results 1 to 13 of 13
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Pa, Pennsylvania, USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Links (97 ?)

    I know the answer is out there somewhere but without the "Search" it seems impossible to find. My question is this: How do I get rid of links that want to open when opening a workbook ? The workbook does NOT need any links but whomever created the thing in the beginning must have had some ideas. I have tried Tools, Options, Calculate, Update References. I uncheck it and it returns checked again.
    Someone have a clue how to get rid of the workbook links.
    Thanks,

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    Hi Tim...

    I found the answer to that question on here long too long ago.... I'd like to give credit to the appropriate person, but I can't remember where I got it... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    The attached file contains an Add-in (I think came from The Access Web site) that will find all links in a workbook and ask you whether to delete them or not... Cool huh?? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    If you need help on installing the Add-in, let me know...
    HTH

    (P.S. This works on Excel 2000 on my machine... Not sure about 97 though...)

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    OOps... Too late... I guess it is Bill Manville's Addin... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

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

    Re: Excel Links (97 ?)

    Just for the record, there is now a Star Post Index in Lounge Matters.

    The Excel section has a Stared Post by our very own gwhitfield which deals with external links.

    Andrew C

  5. #5
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    (Edited by HansV to activate URL - see <!help=19>Help 19<!/help>)

    Another add-in tool for finding and deleting links is the Link Navigator which is part of the Navigator Utilities found at http://www.robbo.com.au. The Link Navigator lists all source link files in a list box which can be sorted by file or path, and then lists all references which use that source file such as cells, names, macros, etc - all listed in another list box so you can easily delete them, or jump to them etc. There is also a 'multiple file' tool which allows you to produce a report list of all source files in a selection of workbooks chosen from a listbox containing all workbooks in a directory with or without it's sub-directories.

    There are other Utilities in Navigator Utilities allowing you to easily find your way through a workbook with many sheets, manage Named Ranges and an enhanced Find/Replace function which has recently been updated.

    It's a free download.

    regards

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Pa, Pennsylvania, USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    Thank you everyone.
    A lot of you answered, most with the same plan.....the Manville plan. It worked and got me out of trouble. It works well.
    Again, this Lounge is and always will be the place to go to find out everything about anything.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Links (97 ?)

    I hate to be "picky" but I am not sure I understand your quote:
    <hr>The only thing that depreciates quicker than a new car, is a Computer (and it's software) <hr>

    The way you have it written with the apostrophe is the same as:
    "The only thing that depreciates quicker than a new car, is a Computer (and IT IS software)"

    I am not sure what your point is.

    Most of what depreciates on a computer is HARDWARE. I wouldn't really describe a computer as SOFTWARE (as your quote does). Also, software does not really "depreciate" that quickly, since you can get upgrades and service packs.

    Do you mean the possessive? (its not it's):
    "The only thing that depreciates quicker than a new car, is a Computer (and its software)"

    ITS = the computer's software?? as opposed to IT IS = the computer is software.

    Steve

  8. #8
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    Steve:

    You lie in your teeth, sir - you clearly LOVE to be picky! I salute a fellow pedant!

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  9. #9
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Pa, Pennsylvania, USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    Again, thank you all for the help with Excel and to Steve for his lesson in English. I believe you to be correct in the possesion tense of the software BUT, according to most software agreements, you never OWN the software, you only lease it. So, in that case, can the "IT'S" be possive seing that the computer (or owner) never really owns the software ? Hummmmm....a conundrum ?
    The use of your "special word" Bilas, made me look up the definition as I am sure that there are many who would like to know what you mean:
    One entry found for pedant.
    Main Entry: ped

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Links (97 ?)

    You still missed my point:

    "IT'S", with the apostrophe, is NEVER possessive. It is ALWAYS a contraction and means IT IS (or even IT WAS or IT HAS depending on context)

    The possesive is ITS (no apostrophe). The way to remember is ITS goes along with the other possesive pronouns HIS and HERS: NONE of them have an apostrophe!

    Your original statement stated that a COMPUTER IS SOFTWARE! and I felt you wanted to reference the software that BELONGED to a computer.

    I do also agree: is the software really the computer's (but I think that is a whole different conversation) and we probably are trying other loungers patience enough with where this thread has gone.

    I apologize to any who are perturbed for starting the tangent.

    Steve

  11. #11
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    Tim:

    Bearing in mind Steve's comment I have posted my reply to a new Scuttlebutt thread.

    Tony
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  12. #12
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Links (97 ?)

    Try the FindLink addin of Bill Manville:

    http://www.bmsltd.ie/mvp/

    or check out the starpost <post#=30606>post 30606</post#> for other ideas

    Steve

  13. #13
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Links (97 ?)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 16:58. to update link to http://www.bmsltd.ie/)</P>Bill Manville's Find Links Add-In available on this site may be what you're looking for. Links can be all sorts of things - including named ranges. HTH
    Gre

Posting Permissions

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