1) Ensure the file is not in open state. (in some cases, even though you close that particular file and not the excel, due to cache, you could get this kind of error, of so close all the excel files and (excel as well) try opening) .

2) Ensure you are able to access the folder where the file is available. (there may be permission issues, because the direct permission is differ from the sql server instance permission)

Regards,

Prabhu