Linked Documents
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Linked Documents

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

    Default

     

    Hi There.

    I created a master document on excel, which consists of worksheets that are individually linked to other Excel Files on a folder. When I opened up the main document, I get an overlay if I want to update the links. When I say yes, I get the overlay to look for certain files. However, those files I don't need. Does anyone know how I can get rid of links.

    I went to links under the edit heading. but there is no way to delete them

    Thanks
    Ernest

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    have you tried under the edit menu
    links
    break source?

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

    Default

    I wrote a neat little utility that will erase links, or change them to values. Email me, if you're interesting send it to you.
    It's never too late to learn something new.

    Ricky

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

    Default

      
    Go to Microsoft.com/downloads and if you search under excel with the keyword set to links you can download a friendly wizard that gives you controlled deletion of links

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