Open Excel 2010 Workbooks in Separate Windows on Windows 10
Question details
The user wants to open Excel 2010 workbooks in separate windows on Windows 10 without disrupting normal file opening.

- Product
- Microsoft Excel 2010
- Device & OS
- Windows 10
- Scenario
- The user wants to view or work with two Excel workbooks in separate application windows.
- Observed behavior
- Workbooks may open in the same Excel application window, and changing the Dynamic Data Exchange setting can interfere with opening files.
Open the first workbook in Excel 2010 and locate the second workbook on your computer. If you previously changed Excel's Dynamic Data Exchange setting, check it before testing file opening.
Open the Second Workbook in a New Excel Instance
Use a separate Excel process to display the second workbook in its own application window.
Open Excel 2010 and use File > Open to select the first workbook.
Hold Shift and click the Excel icon on the Windows taskbar to start another Excel instance.
In the new Excel window, select File > Open and choose the second workbook.
Drag or resize the two Excel windows, or move one to another monitor, so you can view both workbooks.

Restore the Normal DDE Setting for Opening Workbooks
Check this setting if workbooks no longer open correctly after changing Excel's Dynamic Data Exchange options.
Arrange Workbooks Within One Excel Window
Use this option when viewing workbooks side by side is more important than having separate application windows.
Work With Excel Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to continue working with your existing documents as you move between office suites.

Frequently Asked Questions
How do I start a second Excel 2010 instance?
With Excel already open, hold Shift and click its taskbar icon. In the new instance, select File > Open to open the other workbook.
Should I enable the option to ignore other applications that use DDE?
Normally, leave it unchecked. Find it under File > Options > Advanced > General. Enabling it can interfere with opening workbooks by double-clicking them.
Can I view two workbooks side by side without separate Excel instances?
Yes. Open both workbooks in the same instance, then select View > Arrange All and choose an arrangement. They remain inside the same Excel application window.
Will a newer Excel version improve multiple-window behavior?
Newer Excel versions generally provide better separate-window behavior for workbooks. If upgrading is an option, check the version's system requirements and compatibility before installing it.




