How to Open Two Excel Files Side by Side in Two Monitors?

The best solution is using LibreOffice. With LibreOffice Calc, you can open one Excel spreadsheet in one monitor and another speadsheet in other monitor to compare, view or edit.

Change the configuration in Excel 2007 or 2010 is another solution by check the check box 'Ignore other application that use Dynamic Data Exchange'. You may encounter with the run-time error when you attempt to close or open again.

References:

• http://www.lytebyte.com/2008/05/13/how-to-open-two-excel-files-side-by-side-in-separate-monitors
• http://social.technet.microsoft.com/Forums/en-US/w7itproinstall/thread/6ba32569-19a0-4b45-806f-9a42258bdb5f