I've made a spreadsheet with macros built into it that I've been using for some time. Once, when I had another workbook open, I opened this one as well to multitask. I don't know what happened, but ever since then, whenever I open the first workbook it looks for that other workbook (which had nothing to do with the first), giving me a "File Not Found" whenever I open it. For the life of me, I can't find that file in any formula, or any other kind of link to that 2nd file. It's not in any macros either, or in Workbook_Open(). How do I find where this workbook is referencing this 2nd file, and get rid of it?

Thanks!

Sounds like a rouge external link. Does they first file have the Links... option on the Edit menu greyed out or not?

If it is not greyed out then this is probably your problem. In the first instance I'd recommend look through all the range names in your spreadsheet (Ctrl + F3) as they are often a fertile source of obscure external links. If you have no joy with this I do have a fairly extensive bit of code I could post which will (normally!) root out external links.

Thanks maccas! I took your suggestion and finally found where the link was hidden...in a hidden sheet. I extracted it with an addin I found at http://www.bmsltd.ie/MVP/Default.htm

I appreciate your help!