You might try to select the content of the entire table. Then use the Place command with the Show Import Options to place the same spreadsheet file, but choose a smaller data range in the Options dialog box.
Or, if you have simply refreshed the link, you could manually select the unnecessary columns and press Cmd/Ctrl+Backspace to delete rows or Shift+Backspace to delete columns.
Mike Witherell