I looked up a method of opening multiple files in separate instances of MS Excel, as I have both a landscape oriented and portrait oriented monitor and need to use both. The common method of doing so was to enable a function called "Ignore other applications that implement DDE (dynamic data exchange)" or similar.
Now that I have applied this option, whenever I open files in Excel, I receive the error;
There was a problem sending the command to the program.
Microsoft and other sources list the resolution as "Disable the DDE ignore function". This will place me right back where I started.
Is there a method of opening each file in a separate instance of the Office program, without making Office prone to this error?