|I have finally found out that enabling OPTIONS>ADVANCE>IGNORE OTHER...DDE in Excel, I can finally open multiple Windows of spreadsheets so i can move them to different screens and compare side by side. That worked only on Friday. Today, no so good. I keep getting the message "there was a problem sending the command to the program" when opening shortcuts. I can open Excel by itself, and open a file from there. So now, I am back to where I am. Opening multiple Excel programs manually to open up spreadsheets to have in each Window, whether ignoring DDE is disabled or not (which gives the error). Right now I took off the check box to ignore it and back to the "defaulted" way of opening multiple windows for each sheet.|
How can I do this without having the DDE errors or opening multiple Excel programs first before each sheet?
I reply as fast as I can, but it could be hours or months.