Remove data connection from Excel 2010 spreadsheet in compatibility mode

Question

Situation: Excel 2010 workbook is created using data from oracle. For this, a data connection has been created. The excellent workbook is then saved as an .xls file so that clients with older versions of the office can access it.

Problem: When opening a book, a warning message is displayed:

'Security warning. Data connections are disabled [Include Content].

We think this is shown because the data connection is still present in the book. You can go to Data-> Connections and delete it, but when the book is saved and reopened, the data connection will return (albeit with empty fields).

Proven things: deleting all data connections with a macro: no joy. The Name Management method described here (http://www.mrexcel.com/forum/showthread.php?t=467938): no joy.

Has anyone else seen this behavior?

Answer 1

I had the same problem today. If, after deleting all connections, the connection properties still continue to work. I clicked on the properties, deleted the name, selecting the name box and deleting it.

There was a warning that I really wanted to do this. After choosing yes, he got rid of the connection. Save the book.

I am good at Excel, but it seems to have worked.

Answer 2

Select a cell in the cell range in which the data is imported, then select Menu> Data> Properties> Discard query definition.

Properties will be grayed out if no cell is selected in the data import range.

You can find out the range in which data is imported:

Menu> Data> Connections> (select a connection)> Click here to find out where the selected connections are used.

Answer 3

When the Import Data window appears , click Properties and delete. Select the checkbox next to Save the query definition. When the message Import data and your location is where you want to go (Example: = $ I $ 4) click OK and your problem will be resolved

Answer 4

I managed to solve this in excel 97-2003, in a file with the .xls extension as follows: I went to the page where I had the associated data, with the cursor over the imported data table, go to the tab “Design” → “External Data Table” → "Disable" Disable all tables (connections), delete all connections in Data → Conections → Conections, save your work and do it! Regards, Dan

Answer 5

I had the same problem. Get a warning. Went to a data connection and deleted the connection. Save, close again. Still get a warning. I use the xp / vista menu plugin for classic menus. I found the data, I get external data, properties, uncheck the definition of the save request. Save close and reopen. It seemed to get rid of the warning. Just removing the connection does not work. You must get rid of the request.

Answer 6

I experienced that a drop-down menu related to the control range (for example, after copying sheets from one book to another) will save this link to the cell after copying the worksheet and save the data connection, which is invisible in the "Connection". I found this in the Search menu on the ribbon, where you can select an arrow to mark objects. Below the arrow is a menu item to see all the objects listed in the panel. Then you can delete these unwanted objects and the data source / connection is gone ...

Answer 7

Excel 2010: on the “File / Information” page, go to “Related Documents” and click on “Link Break =” a warning appears that all related values ​​will be converted to their data values ​​=> click ok => done