Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link update on opening (Excel 97)

    I have an inherited workbook that contains an invalid link. Every time I open it, I get the update message which, of course, does not work. I read a tip to edit the link and delete it, but Excel will not let me do this. My question: how does one find those links in the workbook (250+ tabs) and/or properly edit the link to delete it?

  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: Link update on opening (Excel 97)

    Check <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 post</A>
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link update on opening (Excel 97)

    Is it just one link? Can you find the cell(s) and just type in the value(s)?

    Check out <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=64576&page=1&view =collapsed&sb=5&o=0&part=>this question</A> too.

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link update on opening (Excel 97)

    Thanks for the advice. Findlink.xla solved the problem by offering on the spot to delete the offending link.

Posting Permissions

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