Office Settings & Configuration

Open Excel 2010 Workbooks in Separate Windows on Windows 10

Elise WilliamsElise Williams Nov 14, 2026 869 views

Question details

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

How to Open Excel 2010 Workbooks in Separate Windows on Windows 10
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.
Before you start

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.

Solution 1Recommended

Open the Second Workbook in a New Excel Instance

Use a separate Excel process to display the second workbook in its own application window.

1
Open the first workbook

Open Excel 2010 and use File > Open to select the first workbook.

2
Start another Excel instance

Hold Shift and click the Excel icon on the Windows taskbar to start another Excel instance.

3
Open the second workbook

In the new Excel window, select File > Open and choose the second workbook.

4
Position the windows

Drag or resize the two Excel windows, or move one to another monitor, so you can view both workbooks.

Open the Second Workbook in a New Excel Instance
Working across instances: Some operations between workbooks, such as copying certain content or linking cells, may behave differently when the workbooks are open in separate Excel instances.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsWork with multiple workbooks in WPS SpreadsheetFree and lightweight for everyday office tasks
microsoft office alternative - wps office

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.