prabhu.st (7/25/2014)
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
+1, additionally, sometimes excel tends to hold the document open even if you close the excel it can happen that excel is closed in the explorer but keeps on running in the background. you can also end that process.