Question posted 2012 · +5 upvotes
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
Accepted answer +5 upvotes
This is what works for me
Open your first Excel file and place it on the screen you want
Open a new Excel file from the Excel icon (New instance of excel needed)
The new file will open on top of the one you have already opened. Drag it to the other screen
Drag the icon for the second Excel file INTO the new (blank) Excel document
Excel is a difficult beast sometimes
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.