We are getting an increasing frequency of errors when opening Excel files at my company. Our employees all use W7 SP1 32-bit and Office 2010 Pro Plus. We store files on a Windows 2008 R2 SP1 File server. The errors have occurred a lot in the last 2-3 weeks, but weren't a problem before then as far as we know.
The error we are seeing is when you double-click to open an Excel file, you get the following message: "<file name> is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen <file name>?"
- When you open Excel first and then open the Excel file, the error message does not occur.
- If you have Excel open and double-click the file to open it, the error message does not occur.
This only occurs when Excel is closed and you double-click the file to open it. There appears to be an issue with 'dde'
If you click 'Yes' to the error, the file will reopen and you can make edits normally & save changes. This error doesn't happen with all Excel files on our network. I think it may have to do with linked data. Some of these Excel files look up to data on an Access database, for example. The database itself isn't 'open' by any user and neither is the Excel file. This isn't a 'file in use' problem.
I can hack the registry (see below) to get the error to go away (removing dde), but I'm looking for a more sustainable fix.
How do I get these errors to stop popping up?
I have tried Repair install of Office on a few machines with no success. When the issue occurs on a particular file, you can reproduce it on a different client. That is, it doesn't seem to be client-specific although you can 'fix' it by changing how files open on the client machine. Again, this has been an error we are seeing a lot in the last 2-3 weeks.
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open] @="&Open" [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command] @="\"C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\"" "command"=- [-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec]