Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: I've tried to unlink another workbook......

  1. #1
    Guest

    Default

    But nothing seems to work.

    I've have a book that's linked to another (actually, it's linked two times). I've tried to change the source, but Excel isn't letting me. It states "Your formula contains an invalid external reference to a worksheet"

    Does anyone want to save my PC from certain destruction?? I'm thankful for any help.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I get that quite a lot when I'm re-linking sheets. It usually means the file you're trying to link to is spelt wrong somewhere like there's a space that shouldnt be there, or an alien fullstop or something. Check the name thouroughly

  3. #3
    Guest

    Default

    Thanks AJ, but I need the workbook unlinked entirely.

  4. #4
    Guest

    Default

    Anyone have any ideas??

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go Here and download the FindLink.xla addin. That should help you.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

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
  •