You are unable to update a link without first opening the source Excel file, since the UpSlide Link Update feature works by scanning all open workbooks for potential sources.
If you haven't yet opened the excel document, you can use the Go to Source feature to open the source in one click, assuming the file has not been moved or renamed. If the source was renamed or moved, you need to open the new file before clicking the Update button.