Mystery Link - It's Driving Me Nuts!

Mar 15th, 2002, 06:30 AM

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?!?!

Thanks

codyswan · Mar 15th, 2002, 11:41 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 06:30 AM	#1
Guest Posts: n/a	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?!?! Thanks

Mar 15th, 2002, 11:41 AM	#2
codyswan New Member Join Date: Mar 2002 Posts: 22	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.