Recently I’ve had an issue where Excel files won’t open properly unless the Excel program is already open itself.
If I double click an Excel file from Explorer (i.e. a folder) then Excel opens (the program opens) but the file does not load. If I then click to open again, al is fine. It seems odd that I need to always have Excel open first. This problems has never happened before and started after my office PC recently switched to Windows 7.
One suggested solution was to go to Tools > Options > General and make sure that Ignore Other Applications is unchecked. This did the trick only once I realised I had to do this for every version of Excel I had installed (I have Excel 2010, Excel 2007 and Excel 2003).
In 2010 and 2007 you need to uncheck “Ignore Other Applications that use Dynamic Data Exchange (DDE)” via Options > Advanced.
So, problem solved…