Error message : The file name or path does not exist; The file is being used by another program; The workbook you are trying to save has the same name as currently open workbook". While opening Excel file in SharePoint

Issue : Trying to download files from SharePoint through either IE or Chrome, however, getting this message: "The file name or path does not exist; The file is being used by another program; The workbook you are trying to save has the same name as currently open workbook"

this happens to any file I try to download 

Solution :

Local office cache was the root cause of the problem only regular users who kept accessing the same files on SharePoint were the ones experiencing this issue. Excel and Word would refer to the office cache files and wouldn't find the documents.

Below are the steps to resolve this issue. Follow steps from 1 to 4 if you need to unhide folders.

1.Right-Click on Start and choose 'Open Windows Explorer'

2.Tools > Folder Options. Choose the View tab.

3.In 'Hidden Files and folders ' select 'Show hidden files, folders and drives.

4.Uncheck 'Hide protected operating system files(Recommended)'

5.Go to C:\Users\username\AppData\Local\Microsoft\Office\14.0\OfficeFileCache

6.Delete the FSD and FSF files from there. There might be one or two files which you might not be able to delete because they are currently being used.

7.Open Internet Explorer browser.

8.Got to Tools>Internet Options>Advanced.

9.Click on the 'Restore advanced settings' button.

10.Close the IE browser.

11.Open the Excel or Word documents from SharePoint as a test.

12.Close the documents.Follow steps 1 - 4 

13.In 'Hidden Files and Folders' select 'Don't show hidden files, folders, or drives'

14.Check the 'Hide protected operating system files(Recommended)'

Finally you need clear the browser history then try to access the document, It will work.