Automatic Link
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Automatic Link

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Everytime I open my workbook, I get an automatic link message. The workbook doesn't relate to other workbook. Is there a way to disable the automatic link ???

    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try:

    Tools, Options, Edit,
    Uncheck the Ask to Update Automatic Links


    Also, check the name ranges in your workbook to see if they refer to another workbook.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried that and it didn't show the message anymore.
    However, because I deleted all the linked files, I got a file not found window when I open the workbook.
    Is there a way to solve this problem???
    Thanks again

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

    Default

    I don't have a quick solution, but the same thing happened to me when I took over a project for someone. I saved the file as something else and started to delete worksheet by worksheet (saving, and reopening) to see if it solved the problem. I was able to locate which sheet had the link and was able to eliminate it from there. It isn't the best solution, but it worked.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks
    I will try that tomorrow.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You may find that these links are not the result of formulas entered into worksheet cells (which should be easy to find once you refuse to update links), but rather references in Defined Names. Take a look at those too! The ASAP Utilities suite (see www.asap-utilities.com.) which is a free add-in includes an Information command that lists all Range names and their referrals. You might find it useful.

    [ This Message was edited by: Mark W. on 2002-04-18 13:25 ]

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Mark or anyone
    If I don't have the Asap utility, how can I find the reference of the Defined Name?
    After I find the reference, what should I do next to disable the automatic linked list?
    Thanks in advance

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have written a utility that will delete links to other workbooks. Let me know if you're interested and I'll send it to you.
    It's never too late to learn something new.

    Ricky

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hello Ricky
    yes
    I will be very appreciated if you could send me a copy of the utility to visitliu@hotmail.com
    Thanks in advance

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