When a link is created, Import Sheet saves the File ID of your Excel spreadsheet. So if you delete this file on Google Drive, Import Sheet will lose its reference and your file will not be updated. You have two ways of updating your Excel file without ‘breaking’ the link:
- Manually, via Google Drive: Right click mouse button and choose “Manage Versions”
- (Recommended) through the Google Drive for Desktop . Using this you can simply replace the same file.
Take a look at the video below that will give you a very detailed explanation of how it works: Linking Excel spreadheets to Google Sheets (Tutorial)