I had a need to open several spreadsheets, side-by-side, on two separate monitors. I was told that checking the "ignore other applications that use DDE" checkbox in the Excel Options - Advanced tab.
I am now able to open two separate instances of Excel, but can only open actual workbooks by saving them and then navigating to them via the Excel - Open menu. I cannot double click on the workbook in Explorer or Outlook to open the file.
Is there a way to configure my system for multiple instances of Excel that doesn't screw up my ability to open the file directly from Outlook or Explorer?