Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Finding and removing links

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

    Default

    I need to find out how to find links within my sheets and erase them. So far I have had no luck at actually finding the data that is linked.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Might want to try CNTRL/~ to view all formulas???
    Tom

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

    Default

    hiya,

    Things to check:

    1. Did the file not have links earlier, then possibly after copying have the links? Might be phantom links. If not move to (2), otherwise do an editlinkschange source and select the file itself.

    2. Formulation in your sheets. An easy way to search is to go to Tools-Options-View and check "view formulas" so you can scan for links. If you only have that one file open, links really stand out (instead of ='[Book1]Sheet1!A1 you'd see 'C:My Documents...!A1).

    3. Do you have any named ranges? Check InsertNameDefine - you may have named ranges that have source data to another file. you can tweak the source data or delete the offending named range from there.

    4. Any Charts? Check each data series in your charts to see references to other files.

    Good luck,
    Adam

  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

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

    Default

    I found some named ranges and deleted them so thanks for the tip.


Some videos you may like

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
  •