Excel 2007 Network Error: Cannot find file …
When using Excel 2007, I’ve had problems with this error occurring when I tried to open an .xls or .xslx file for the first time. The file would open on a second attempt but not the first. I had assumed that it had something to do with my files being on a network drive instead of being stored locally. Anyway, I was always too busy to deal with it; however, this week I began getting the error on every attempt to open an Excel file. The only way I could get the file to open would be to start Excel and then open a file from within. I finally broke down and did some research.
First, I checked my file associations, reset them, and that did not work. Then I tried manipulating the permissions and this did not work either. Finally, I found the resolution:
1. Open Excel
2. Click on Orb
3. Click on “Excel Options”
4. Navigate to “Advanced” in the left pane.
5. In the right pane, scroll down until you seea “Ignore other applications that use Dynamic Data Exchange” and uncheck the checkbox.
Previous Version of Excel: Navigate to Tools –> Options –> locate and uncheck the above checkbox