With Windows XP, the option to display multiple excel 2007 instances at once could be achieved by checking the "Ignore other applications that use Dynamic Data Exchange (DDE)" checkbox. In Windows 7, when this option is checked, an error comes up stating "There was a problem sending the command to the program". I work at an accounting firm, so the ability to run multiple workbooks in different excel instances is absolutely crucial for daily workflow. Below are the steps I have attempted to get multiple excel instances running in Windows 7. If no one can offer a viable solution to this problem, I will be downgrading to Windows XP and will not deploy Windows 7 in our office until Microsoft acknowledges and resolves this issue.
- I have ran excel 2007 in every compatible mode listed and tried switching the 'Run as Administrator' option off and on with each compatible mode.
- I attempted to edit the startup command for excel to the following: “C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE” /e “%1″ , but could not locate which registry setting to change ("The application to perform action" field has been removed from the folder options in Windows 7).
- I installed the runexcel batch file, pointed all .xls and .xlsx files to run this batch file instead of excel 2007, and changed the icon settings. This allowed for multiple instances of excel to be opened from a saved file. However, we use a program called Engagement that utilizes accounting binders that have excel sheets in them. When opening excel files from this program, the files don't seem to associate with running in the batch file and revert back to opening in a single instance. It seems that the workaround needs to be tied directly to Microsoft excel and not to a batch file.
- The option to span an excel instance over two monitors and open two workbooks in one spanned instance is not a viable option. Each accountant opens dozens of excel sheets every day, which makes the workaround far too unwieldy.