Unable to delete data connection from Excel file

[CHOCOx33]

I want to remove the data connection preset inside the Excel 2003 file, but I still cant delete it permanently. Everytime I delete it and close it, it will be back again when I open it again.

I even follow some tips such as http://www.mrexcel.com/forum/excel-questions/467938-remove-workbook-connections.html but I still cannot find the defined name in the Name Manager. So how will I delete the connection? I even follow every available method but I still cannot get rid of the connectionstring.

Apparently, the file was given by my supervisor so I need to remove the connection before I can use it for my OfficeWriter coding. Any idea on how to remove the connection without a defined name?

 

[Jon von der Heyden]

I'm struggling to grasp "connection".

Are you talking about a link to an external file, or a connection pertaining to a query?

Have you had a look at connections in your Data tab? http://office.microsoft.com/en-au/excel-help/break-a-link-to-an-external-reference-HP010342210.aspx

 

[CHOCOx33]

Hi, oh sorry i did not make myself clear again. Yes it is a link to an external file, which is a Microsoft database (.mdf). I want to remove it but not to avail. Any solution on this?

 

[Jon von der Heyden]

Did you try my suggestion - Click connections on the Data tab and remove it from there?

 

[CHOCOx33]

I have followed your suggestion but I dont see the Edit Links button on the excel file, which I think it dont have any linked information

 

[Jon von der Heyden]

Hi

Edit Links refers to formula references - this appears to be a connection - which is different.

What version of Excel are you using? If you are using a version with the ribbon, there is a connection control on the Data tab. See image below: