Mystery Link - It's Driving Me Nuts!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Mystery Link - It's Driving Me Nuts!

  1. #1


    I have a master workbook that is linked to 20+ other workbooks and for a year has worked great. All of the above workbooks are in a folder named for the month. Each month, I copy the prior month's folder and then change the name. I'll change any workbook names in the new folder, as well, if needed, i.e. they also have the month in the name.
    My dilemma is that just recently, when I open the master workbook and try to update the links, Excel is trying to find "Book 1". If I hit Cancel when the "File Not Found" dialog box opens, the other links update just fine. I have searched all of my workbooks, including the master, for a formula with a reference to "Book 1" with no avail. I've also checked the modules associated with the workbooks. Does anyone have any ideas?!?!


  2. #2
    New Member
    Join Date
    Mar 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    Check the range names. There is probably a named range which you once referred to that is still linked. There doesn't have to be a current formula reference to it. Excel will often keep the named range on the list.

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