Remove the data connection from an external data range

1. Click the worksheet that contains the external data range from which you want to remove the data connection.
2. On the formula bar, click the arrow next to the Name box, and then click the name of the external data range from which you want to remove the data connection. The data range is then selected.
3. On the Tools tab, in the External Table Data group, click Unlink. The data range remains, and still bears the same name, but the connection is deleted.

See also:

• Refresh connected (imported) data
• Use Microsoft Query to retrieve external data