Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Monte Sereno, California, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove Auto Link? (2000 SR-1)

    I copied out one sheet of a multiple sheet workbook and asked for an auto update. I have since deleted the single sheet file; however, I am still asked about an update every time I reopen the master workbook.

    How do I get rid of this link? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Remove Auto Link? (2000 SR-1)

    Try looking at this post or at <A target="_blank" HREF=http://www.cpearson.com/>http://www.cpearson.com/</A>
    Gre

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

    Re: Remove Auto Link? (2000 SR-1)

    Unkamunka,

    Thanks for the pointer. <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=30606&page=&v iew=&sb=&o=&vc=1#Post30606>This reply</A> to the post you pointed provides a little more info. If anybody has any further feedback to this, it would be worthwhile for people who come later.

    I had a look at <A target="_blank" HREF=http://www.cpearson.com/> Chris Pearson's site</A>- I couldn't find anything there- have I missed something?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

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

    Re: Remove Auto Link? (2000 SR-1)

    Geoff

    I first used Bill Manning's add-in some time back, and refound the site by using the Lounge. My only beef is that, although it tells you where the link is to, it doesn't tell you where it is in the file you're cleaning. I thought of posting a link to the reply as well, but wasn't sure whether that would snow our new Lounger under.

    In zonks old versions of Excel, you used to be able to open up the places where the links were by clicking on the Links dialog box - a user-friendly feature that probably died due to links starting to be in all sorts other places than cells (pity though).

    There was a FindLinks utility on Chip's site a while back (see this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=32949&page=&v iew=&sb=&o=&vc=1#Post32949>post</A> and its reply). To my surprise, it is one of the few things that seems to have been taken down recently.
    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
  •