Opening files and windows in a separate instance of Excel.

On my home laptop I have excel 365 which always opens new files or new window of the same file in a separate instance of excel.

However on my work laptop all files and window are in the same instance of excel separated by tabs.

How can I get it to always open in a new instance of excel so that I can send it to the other monitor.

I have Windows 10 on both systems.

Edited: The taskbar shows two different instances of excel.

Microsoft ExcelMicrosoft Office

Last Comment

Saqib Husain

8/22/2022 - Mon

Kimputer

12/19/2019

Save as .reg, and run it:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\Open]
@="&Open"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open]
@="&Open"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\OpenAsReadOnly]
@="&OpenAsReadOnly"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\OpenAsReadOnly\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\OpenAsReadOnly]
@="&OpenAsReadOnly"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\OpenAsReadOnly\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""

Open in new window

Saqib Husain

12/19/2019

ASKER

The system did not accept it from my user account. So I went to the admin account and ran it successfully.

But back in my account the same situation persists.

Kimputer

12/19/2019

I forgot to mention you should change this:

C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE

to whatever folder you use.

My specific solution was for 2010. You will need a slightly different path.

Your help has saved me hundreds of hours of internet surfing.

fblack61

Kesavan Jeganarayanan

12/19/2019

If you want to view workbooks on two screens, you'll have to start two separate instances of Excel.
Start Excel, then Shift+click the Excel icon on the Windows taskbar to open a second instance, and drag the new window to the other screen (if it is maximized, un-maximize the window first).

Saqib Husain

12/29/2019

ASKER

Found it.

It was the