Can't figure out how to remove data connection

**CKlapperich** · 08-04-2014, 03:57 PM

I was messing around with data connections and importing stuff from a network in real time. Cool stuff. But everytime I open ANY excel worksheet on this computer, it tells me "file cannot be found" and refers to one of the first files I used for this. this happens no matter what workbook I am opening. how do I fix this / remove it? Thanks.

EDIT: Yes, when I click data --> connections its empty.

**mikeTRON** · 08-04-2014, 04:49 PM

Typically it is a named range or a data validation for me but you can use the following links to look for the links.

http://office.microsoft.com/en-us/ex...010205611.aspx
http://office.microsoft.com/en-us/ex...003056096.aspx

Or post the workbook and I will find it for you

**CKlapperich** · 08-05-2014, 08:32 AM

I don't think its just a matter of deleting the links in question. I can have no excel workbooks open, then open a new one, and I get that file not found error.