SYMPTOMS
When you double-click a Microsoft Excel workbook (.xls file or .xlsx file) in Microsoft Windows Explorer, Excel does not open the file, and you may receive the following error message:
In Window Vista, when you double-click an Excel workbook, Excel does not open the file, and you may receive the following error message:
Excel may actually open, but the file will not open. If Excel is already running, a second instance of Excel may start.
CAUSE
This problem may occur if the Ignore other applications setting in Excel is selected.
RESOLUTION
To resolve this problem, follow these steps:
| 1. | In Microsoft Office Excel 2007, click the Microsoft Office Button, and then click Excel Options. |
| 2. | Click Advanced, and then click to clear the Ignore other applications check box in the General area. |
| 3. | Click OK. |
| 1. | In Microsoft Office Excel 2003 or earlier versions of Excel click Options, on the Tools menu. |
| 2. | Click the General tab. |
| 3. | Click to clear the Ignore other applications check box, and then click OK. |
MORE INFORMATION
When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel, instructing it to open the workbook that you double-clicked.
Thanks a lot!
This happens to me in pre-2007 Excel (2002/XP and 2003, when opening a workbook from out of Outlook so it is not only occurring on Excel 2007.
I have a similar problem not opening files but only when an Add-In I developed is loaded; without the Add-In, the file opens fine.
I have the strong believe the DDE interface in Excel is not properly serialized with the rest of the environment or that the launching application (Explorer, OL, …) is too slow with the DDE call while Excel is already looking for the file and does not find it.
It is recommended to keep DDE ‘active’ if you want to open workbooks in a single Excel instance.
Dutch