Links
Links
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Links

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do you remove old links in a file when you cannot find where they exist? I've tried find/replace with the link name. I've tried search for formulas. I'm at a loss. Any help would be appreciated!!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey

    Try Edit-Links-Change Source. If you select your open file itself it should close the loop and kill the link (if phantom). If you get an error you likely have a Named range, formula, or chart series with an external reference.

    Adam

  3. #3
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go to Edit > Links. Click the link you want remove and click change source. Then select the file name of the file you have open and click whatever the name of the button is to close the dialog box.

    You are basicly linking the data to itself which removes the errent link. Just be sure the link is actually not wanted.before you do it

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Netherlands
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I had a similar problem, Tom Urtis gave me this link
    http://support.microsoft.com/default...;EN-US;q188449
    worked for me

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com