To Remove a Link to an External Spreadsheet
Click inside a cell within the data linked table to select the cell.
Right-click and click Data Links
Detach Data Link.
Related Concepts
About Linking a Table to External Data
Related Tasks
To Link to a Table in an External Spreadsheet
To Open an External Spreadsheet From a Data Link
Related Reference
Commands for Tables