How to Open Two Excel Files in Multiple Monitors in Windows 7 pro excel 2010? [closed]

Question

I want to open two (or more) excel windows on different screen (extended displays), But was not able to. I tried few solutions found on Google.

One worked, that was making changes in registry and after that checking the option 'Ignore other application that use DDE'. Now I am able to get separate excel windows but same time I get this error 'There was a problem sending the command to the program'

How to avoid this error. Can someone help me in this?

Thanks Ritesh

Answer 1

This is what works for me

1. Open your first Excel file and place it on the screen you want

2. Open a new Excel file from the Excel icon (New instance of excel needed)

3. The new file will open on top of the one you have already opened. Drag it to the other screen

4. Drag the icon for the second Excel file INTO the new (blank) Excel document

Excel is a difficult beast sometimes

Answer 2

What I've done is opened up one saved excel document. Then, instead of locating the second excel document and double clicking on it to open, I just went to the start button and clicked on Excel to open up a new blank document. This will give you 2 excel windows. In the 2nd excel window, open up your second excel document by going to file / open / and then browse for your 2nd excel file. Now you will have 2 excel documents, each in their own window.