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

Thread: Data linked to other workbooks

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

    Default

    I have a rather large workbook that when I open, gives the message that there are links to other workbooks, would I like to update them. There shouldn't be any links to other workbooks. If there are accidentally links, I really need to find them so as not to mess up my data. Is there any way to determine where these links might be?

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    First thing is find out where they are linked to. Use Edit->Links. This will tell you the link. Then search on the keyword to see where the link is and delete it. Of course, I have come across the problem where I change from Link A to Link B and some of Link A still shows up where only B should be. The only way I have found around this is clearing the cell and reentering the information. Hope this helps.

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
  •